If Cell A is X, how to auto populate outcome?

[SB lightning]

Hi all,

I'm creating a spreadsheet with a list of different names and a rating associated with those names. I have the "master list" in order with the names in column A1-A32 and their rankings in column B1-B32. Now in C1-C50 I have all of those names in the A column but randomly assorted. How can I have column D1-D50 automatically put in that names ranking when that name pops up in a cell in column C?

EX

A	B	C	D
Al	4	Dan
Bob	1	Al
Dan	5	Rick
Rick	2	Zeus
Zeus	3	Bob

<tbody>
</tbody>

Thank you in advance!

 

[alansidman]

In D1 =vlookup(C1, $A$1:$B$5,2,0) and copy down

 

[SB lightning]

In D1 =vlookup(C1, $A$1:$B$5,2,0) and copy down

Wow I was really complicating it before. Thank you so much! Worked like a charm!