INDEX MATCH multiple critera

Hey guys,

Thanks for your help. I have a row with 1 criteria (A), a row with another (B), and a third row with an output. I want to be able to change a cell that selects criteria A and it show the scores related to each of criteria B. I know I haven't explained that so well so have attached an example document.

For those who may not be able to access the file, on one page I will have:

Game - Game 1 Game 1 Game 1 Game 2 Game 2 Game 2
Player - Jerry Jimmy Phillip Jerry Jimmy Philip
Match Score - 9 8.5 7 6 6.5 9

I want to be able to select 'Game 1' and display:

Jerry - 9
Jimmy - 8.5
Phillip - 7

This is my formula at the moment: =IF($AY$16:$BD$16=$AX$9,INDEX($AY$18:$BD$18,MATCH(BA24,$AY$17:$BD$17,0)))
which works for Game 1, but if I change cell AX9 to 'Game 2' I get errors

Thanks

Callum
Newbie