Until the OP tells us the columns of data are the opposite way around to that
which we have all assumed and it becomes a left lookup :)

Mike

"Sam Wilson" wrote:

Roy,

The consensus seems to be VLOOKUP...


"Pete_UK" wrote:

You would normally use VLOOKUP for this. Suppose your list of
Employees and codes is in Sheet1, columns A and B, and in Sheet2 A2
you enter an employee name, Then you can put this formula in B2 of
Sheet2:

=VLOOKUP(A2,Sheet1!A:B,2,0)

Hope this helps.

Pete

On Sep 8, 2:07 pm, Roy wrote:
I have a list of employees and cost codes. I'm wondering how I get a excel to
insert a code from a list of code if another cell equals a certain employee.