Index-Match Issue (I Think)

Originally Posted by benishiryo

hi Rick. not really sure what you need. you need to return the Points when there is a "6" shown? how about:
=INDEX($I$1:$Q$1,MATCH(6,I3:Q3,0))

Hi,

Thanks for replying. That's almost what I need, but I also need to act almost as a vlookup, because the position of '6' for 'AA' is different to that of 'BB'. Essentially, I want to have a list of names (AA, BB, CC etc) and to look up the points value of '6' in each case.

Regards,

Rick