D
D Rodriguez
I have a sheet that returns a name based on a specific
ranking. Sheet 2, Column A looks like this.
A Proposed Column
1 John 53
2 Linda 32
3 Karen 87
4 Moe 12
5 Chris 1
6 Dave 7
7 Harry 5
On Sheet 1, Column Z, there are numbers that represent an
OVERALL ranking (vs a more specific ranking).
A Z
Harry 5
Linda 32
Moe 12
Chris 1
Dave 7
Karen 87
John 53
I need to use a function(s) that will look as my list
above (Sheet 2, Column A), match it up with the same value
in Sheet 1, and return the value that is in Colunm Z.
ranking. Sheet 2, Column A looks like this.
A Proposed Column
1 John 53
2 Linda 32
3 Karen 87
4 Moe 12
5 Chris 1
6 Dave 7
7 Harry 5
On Sheet 1, Column Z, there are numbers that represent an
OVERALL ranking (vs a more specific ranking).
A Z
Harry 5
Linda 32
Moe 12
Chris 1
Dave 7
Karen 87
John 53
I need to use a function(s) that will look as my list
above (Sheet 2, Column A), match it up with the same value
in Sheet 1, and return the value that is in Colunm Z.