Lookup, match it, return a value

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Match value return a text 6
Match and delete rows on two different sheets from reference numbers 4
With F1 value, look at A, if match or partial match return B 5
INDEX MATCH SMALL 12
Lookup / Match ? 8
Lookup 2nd & last match with two conditions 6
Return a name in the same row 3
If, Lookup, Match or a combination of all 3

Top