If values are repeated in the left most column of my vlookup table, how do I get Excel to return differing values from other columns? I'm rank ordering golfers according to score, lowest score (ranks 1st) to highest score. The Rank is the Vlookup first column, and if two golfers scores are the same, their rank is the same, yet the Vlookup function repeatedly returns only the first golfer's name. Is there a means for returning the name of the second/third/fourth etc golfer which has the same rank?
Example: Random golfers names, scores and ranking
A B C
1 Rank Score Name
2 2 74 Adams
3 5 76 Anderson
4 2 74 Christopher
5 1 72 Martin
6 2 74 Smith
Without using Sort function, since I would like the spreadsheet to be static, I wish to place golfers in rank order as follows on another section of the spreadsheet:
A B C
10 Rank Score Name
11 1 72 Martin
12 2 74 Adams
13 2 74 Christopher
14 2 74 Smith
15 5 76 Anderson
Formulas for Rank and Score are fine, but formula for Name returns Adams for each occurance of Rank "2", when need second and third occurrances of Rank "2" to return Christopher and then Smith.
Current formula being used which doesn't accomplish objective:
(When I went to post, spacing between columns went away; hope you can read.)
Thanks in advance for any assistance.