Jayman

Try this:

Build your lookup table just the way you posted your example.

Assuming that table is located on a sheet named LISTS in A1:C100, with
column titles in Row_1 (Employee_ID, Employee_Name, etc)

Then....on another sheet....where
A1: Emp_Id
A2: (an Employee_ID)
B1: Name
B2: =VLOOKUP(A1,'LISTS'!$A:$C,2,0)
C1: Dept
C2: =VLOOKUP(A1,'LISTS'!$A:$C,3,0)

(Note: instead of typing the table location, you can just use the mouse
to switch sheets and select it. Excel will build the reference for you)

Copy the formulas in A2:C2 down as far as you need.

Does that help?
---------
Regards,
Ron


--
Ron Coderre
------------------------------------------------------------------------
Ron Coderre's Profile: http://www.excelforum.com/member.php...o&userid=21419
View this thread: http://www.excelforum.com/showthread...hreadid=546194