There are about 500 managers, when I choose a manager's name from a drop down
(in a form) I want excel to insert the manager's file number in an adjacent
cell.

i.e. Joe Button - 1875
Sally Field - 1745
Carl Redding - 1590