=INDEX(A2:A21, MATCH(MAX(C2:C21), A2:A21))
In some cells instead of showing the correct names, its showing other names and in a few cases it shows #N/A which means MATCH found more than 1 highest/lowest scores when infact that's not the case. Also, when I sort the table in a different way (keeping the data unaltered) it shows different results.
I think its having problems with the MATCH function. Excel says so when I go to "show calculation steps".
Got any clue?
Thanks in advance.
Edited by XenoZodiac, 12 March 2012 - 01:39 AM.