look up max

[CTURNER82]

Hi. This seems like it should be simple but I'm not having any luck. If
column A is a list of names and B is a list of corresponding numbers (like
test scores), in C1 I want to find the highest score in B and show the name
of the person to whom it belongs. I can find the MAX in column B, but can't
seem to get beyond that.
Any help would be appreciated.

 

[Don Guillett]

try this where col i has the numbers and col h has the names
=INDEX(H:H,MATCH(MAX(I:I),I:I))

 

[Niek Otten]

=INDEX(A1:A3,MATCH(MAX(B1:B3),B1:B3,0))

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

| Hi. This seems like it should be simple but I'm not having any luck. If
| column A is a list of names and B is a list of corresponding numbers (like
| test scores), in C1 I want to find the highest score in B and show the name
| of the person to whom it belongs. I can find the MAX in column B, but can't
| seem to get beyond that.
| Any help would be appreciated.