You can use VLOOKUP to find the supervisors for sheet 1 from sheet 2
In the column next to the personell in the short list try this formula

=VLOOKUP(A1,Sheet2!$A$1:$B$3000,2,FALSE)

The formula will look at A1 in your short list. It will then go to sheet2
(or the name of your master list) to find the persons name. Once found it
will look at the 2nd column from the name (name 1st column, supervisor 2nd
column) and will return the supervisors name. The FALSE part just tells the
formula that you want an exact match.

See if that works for you.


"boilermaker" wrote:

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?