data validation cell populating another cell

[PinkHinky]

In column E, I have validated those cells using data validation allowing only items from a list to be populated. There are 7 physician names on this list. In column F I have an area for their physician number to go. Each physician has a three digit physician number exclusive to them. What I'm trying to do is when I select a physician from Column E's drop down box, I would like to have in the corresponding row in Column F, their unique physician number populating the cell. How would I go about doing this?

 

[nbrcrunch]

Somewhere else in the file have a list by physician name and code.

Use vlookup based on the name and returning the code.

 

[PinkHinky]

Is vlookup the only tool I can use for this? I'm not familiar with that.