How do I get the Vlookup to not return duplicate results?
For Example:
Column A Column B
x 2
y 1
Z 3
A 1
Now if I am ranking them, and there are two 1's, and that is the best rank in the group, how do I get the Vlookup to return in the first lookup Y, then in the next lookup one cell down, the vlookup result would A. Right now my formula has it where it consistently pulls Y for both formula's.
For Example:
Column A Column B
x 2
y 1
Z 3
A 1
Now if I am ranking them, and there are two 1's, and that is the best rank in the group, how do I get the Vlookup to return in the first lookup Y, then in the next lookup one cell down, the vlookup result would A. Right now my formula has it where it consistently pulls Y for both formula's.