=VLOOKUP(A2,'Sheet 2'!A:B,2,FALSE)

--
Best Regards,

Luke M
"boilermaker" wrote in message
...
I've got a listing of 3000 personnel. Personnel in column A, supervisors
in
column B.
In a separate worksheet, I have a listing of 400 personnel in column A.
Same names in column A, sheet 1 as in column A, sheet 2, just a shorter
listing in sheet 1.(smaller worksheet).

Short list: Sheet 1
Master list: Sheet 2

How do I get EXCEL to compare sheet 1 with sheet 2, and fill in the
appropriate supervisor in sheet 1?