Drop Down List with an IF function?

Hello,

I am having trouble trying to figure this out. Here is what I am trying to do:
I have made a drop down list of 5 names. These 5 people are associated with a certain number. When I choose a name from the drop down list, I need the cell next to it to populate their assigned number.

I have tried the IF function but it seems I have too many criteria for this...

Please help me! Thank you

Hi
Try this

Formula:

Please Login or Register  to view this content.

Where C3 is your dropdown cell, k2:l6 are the table with names and codes

See the file

Put names in A1:A5

Numbers in B1:B5

DV in C1

in D1

=VLOOKUP(C1,$A1:$B5,2,0)

That worked!! Thank you so much!