@benjamip

You don't show the context in which you apply the formula. Though, two matters come to mind:

1) You index a range from row 5 to 53, but the row match looks at rows 5 to 52. Is that intentional?

2) The lookup value for the row match ($A26) is part of the indexed range. I would expect the indexed range NOT to include row headers in column A and the lookup value not to be included inside the lookup range. Let's suggest that the lookup value is entered in C1.

Then, I imagine you would need this formula:

=INDEX($B$5:$H$53,MATCH($C$1,$A$5:$A$53,0),MATCH(B$1,$B$5:$H$5,0))

Now, with the introduction of new functions we indeed have XMATCH. More flexible and probably better, but not sure if you will notice any performance difference unless you deal with huge data sets.

Using XLOOKUP is also an option. That could be something like this:

=XLOOKUP($C$1,$A$6:$A$53, XLOOKUP(B$1,$B$5:$H$5,$B$6:$H$53))

If all of this makes no sense, please upload your file. Just remove anything confidential.

Thanks Riny