Rank/Vlookup? Question

Sorting as hoyasaxa215 suggested, or a Pivot table, would work much better I think.... This is probably overkill.

Make the BOLD RED reference in this formula point to the rank number you are looking for (a cell that contains the number 1 for example would be rank 1)
Make the BOLD BLUE number the total number of player names who are ranked
Make the BOLD GREEN areas the range which contains the number of goals scored
Make the BOLD BLACK area the list of player names

Hold Control and Shift when you press Enter to input this formula properly. Start at Rank 1, and copy/drag the formula down.

=INDEX($A$1:$A$7,SUM(ROW($1:$7)*(--($B$1:$B$7=LARGE($B$1:$B$7,A14)))))


Alternately, if you don't want to have to put a 1, 2, 3 in the bold red, replace the bold red with ROW(1:1)
=INDEX($A$1:$A$7,SUM(ROW($1:$7)*(--($B$1:$B$7=LARGE($B$1:$B$7,ROW(1:1))))))