Index-Match Issue (I Think)

**rormis** · 10-24-2012, 03:44 AM

Hi,

I'm at my wit's end trying to sort this out!

Using the sheet attached I need a formula that tells me the number at the top of the column, for example where Col H='AA' and Row 3=6 then 4, where Col H='BB' and Row 4=6 then 5 and so on.

Please help before my head explodes!

Regards,

RickBook1.xlsx

**benishiryo** · 10-24-2012, 04:30 AM

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))

**rormis** · 10-24-2012, 05:43 AM

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