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