Let's say you have this data listed in A1:B3

This will work if you don't have more than one person getting the same
score.

Highest score
=INDEX(A$1:A$3,MATCH(LARGE(B$1:B$3,1),B$1:B$3,0),0 )

2nd highest score
=INDEX(A$1:A$3,MATCH(LARGE(B$1:B$3,2),B$1:B$3,0),0 )

3rd highest score
=INDEX(A$1:A$3,MATCH(LARGE(B$1:B$3,2),B$1:B$3,0),0 )

"Cricket" wrote in message
...
tom 100
sue 200
bill 300
with a list of scores i can get 1st 2nd 3rd on down, and I can put the
name
with the max score. How can I get the name with the 2nd, 3rd on down.PLS
Help