look up max
 

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.

look up max
 

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

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"CTURNER82" wrote in message
...
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.

look up max
 

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

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"CTURNER82" wrote in message ...
| 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.