Getting stuck on Index Match Match in Excel

Question

Im getting stuck with an index match that I want to do. I want to look up years on both rows and columns and drop in the value from a table on the left. Please find attached a screenshot.

The Code that im using is : =INDEX($F$2:$F$64,MATCH($H8,$E$2:$E$64,0),MATCH($H8,$J$1:$BS$1,0))

Answer 1

Try this one:

=INDEX($F$2:$F$64,MATCH($H8,$E$2:$E$64,0),MATCH($H8,$I$1:$BS$1,0))