Hi,

If you have titles in the top row then change GS's to

=OFFSET(A1,MATCH(MAX(B:B),B:B,)-1,0)

or shorten the other suggestion to

=INDEX(A2:A10,MATCH(MAX(B2:B10),B2:B10))

or try this instead:

=LOOKUP(MAX(B2:B9),B2:B9,A2:A9)

If you have a tie for the MAX these formula will give different results.

--
If this helps, please click the Yes button.

Cheers,
Shane Devenshire


"Fanny" wrote:

Dear Helpers,

I have a long listing below for checking

Name Score
Peter 70
Anna 120
Sam 50
.......


I use Max to find the highest score is 120 and I want to use the highest
score to look for the name who gets the highest score.

How to do so,

thanks a lot for your help.

Fanny