Problem:

Range A1:B6 contains salespeople\'s names and their total number of sales.
We want to rank the top 3 salespeople according to their sales performance.
Solution:

Use the INDEX, MATCH, and LARGE functions as shown in the following formula:
=INDEX($A$2:$A$6,MATCH(LARGE($B$2:$B$6,A9),$B$2:$B$6,0))