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? I'm an intermediate level excel user.