Retrieving the Player Who Scored the Highest Number of Points

Problem:

Column B contains the number of points scored by each player listed in column A.
We want to retrieve the name of the player who scored the highest number of points.

Solution:

Use the INDEX, MATCH, and MAX functions in the following formula:
=INDEX(A2:A9,MATCH(MAX(B2:B9),B2:B9,0))