Forum Discussion
Solved
Match query giving odd answers
Ave, I've got a workbook with 5 sheets. One of which is a scoring sheet with a grid: On the other sheets, I've got tables much like the following: And in the 'Rank' column I'v...
I've just worked out what I was missing. For each of the Match statements (MATCH($C5,Scoring!$E$4:$J$4) I was missing a return context on the end, in this case I've just put an extra comma, and now it works fine.
=INDEX(Scoring!$E$5:$J$9,MATCH($C5,Scoring!$E$4:$J$4,),MATCH($D5,Scoring!$D$5:$D$9,))
So even with the index range changed to $E$5 instead of $D$4 - it's still broken, but for a different reason?
Bother.
I've just worked out what I was missing. For each of the Match statements (MATCH($C5,Scoring!$E$4:$J$4) I was missing a return context on the end, in this case I've just put an extra comma, and now it works fine.
=INDEX(Scoring!$E$5:$J$9,MATCH($C5,Scoring!$E$4:$J$4,),MATCH($D5,Scoring!$D$5:$D$9,))