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?