=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.