Hi!

Try this:

=INDEX(A1:A10,MATCH(MAX(B1:B10),B1:B10,0))

What happens if more than 1 person rolls the high score?

Biff

"Cricket" wrote in message
...
if i use max to find the bowlers high score, how can i find the bowlers
name
who bowled the high score??