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,))
ALMIS_Rob Try changing your INDEX range to $E$5:$J$9
That just gives me a '#REF!' error - it's my understanding that the index range needs to include what you're using as search reference? (in this case the D column with the headers for Consequence (Neg, Minor, Moderate, etc)