Name based on highest score

**inayat** · 10-11-2011, 03:05 AM

Hi All,

Please find attached the sheet. What I want is that the name of the person in Row 4 should come up based on the highest score in row 29. I believe it is a mix of Index, Match and Max but for the life of me can not figure it out...

Cheers-
Inayat

**Bob Phillips** · 10-11-2011, 03:12 AM

Try

=INDEX(D4:F4,MATCH(MAX(D28:F29),D29:F29,0))

**arthurbr** · 10-11-2011, 03:15 AM

Perhaps =INDEX(D4:F4,,MATCH(MAX(D29:F29),D29:F29,0))

**inayat** · 10-11-2011, 04:07 AM

Thats exactly what I needed... Thanks guys... I was making a simple mistake.. I was giving the entire range in the matach lookup array instead.. the formula that I was using was:
=INDEX(D4:F4,MATCH(MAX(D29:F29),B4:F29,0))

EDIT: Just a small thought... what happens if the score is same for two people... it will take the first one.. what if I want it to display both the names...