Quote Originally Posted by exsam21
Here is the problem that I am having. I have 50 employees and I have three columns with 'employee #', 'Last Name', and 'First Name'.

A B C
Emp# Last First
1 Smith John
2 Doe Jane
. . .
. . .
. . .

I want to set up a formula so that when I input the number "1" on cell D1, "Smith" will populate E1, and "John" will populate F1. And if I were to input "2" in cell D1, "Doe" will populate E1, and "Jane" will populate F1. Thank you very much.
ASSUME that your table range is A1:C50, enter this formula in:

Cell E1: =vlookup(D1,A1:C50,2,0)

Cell F1: =vlookup(D1,A1:C50,3,0)

Regards.