Hello -

I need a formula or code for the following scenario:

Sheet 2 has two columns; one with the name (A) and one with the employee
number (B).

Sheet 1 has many columns, but the ones I'm concerned with are Employee Name
(Column A - value I need to look up and insert) and the employee number in
Column B.

I would like to look up the employee number on Sheet 2, column B, then take
the corresponding employee name from Sheet2 Column A and put it into Sheet1,
Column A.

Any help will be greatly appreciated!

--
Sandy