Didn't work. Entered the exact formula and all I get in column B when
copying down is the first value in A1...
--
KM


"Sheeloo" wrote:

If you have both lists in Col A of Sheet1 and Sheet2 respectively, then in B1
of Sheet1 enter
=VLOOKUP(A1,Sheet2!A:A,1,False) and copy down.

Filter on Col B on #N/A... these will be the missing from Sheet2, Col A

"Mossykel" wrote:


I have a master list of people and their ID number in worksheet 1. I'm
trying to find the missing individuals from what I have in worksheet 2 and
put them in a new worksheet 3. Please tell me the easiest way to do this...

Thank you,
--
KM