Two-way lookup with INDEX and MATCH row and column not working

[wiscochris]

Hi, I'm hoping someone can help.
I have a list of student names in column A. The title in column B may change from "score" to "major" or "age". The results from E2 to G5 should then match results under that title.
In this example, the student scores should be;
Mack 88
Sam 74
Call 65
Alex 87.

Could someone please look at my formula and help me fix it so that it generates the expected results?

Any help would be appreciated.

 

[EFANYoutube]

Hi wiscochris
Try this

=INDEX($D$1:$G$5,MATCH($A2,$D$1:$D$5,0),MATCH(B$1,$D$1:$G$1,0))

 

[wiscochris]

Perfect! Thanks VERY much. That was driving me crazy

 

[EFANYoutube]

Your welcome
Yeah I know, used to annoy me too