Need help looking up data-vlookup isn't working

[MMcGee]

I have 2 worksheets. Column A in sheet 1 contains values that I know are in
column A of sheet 2. I need only the rest of the values in sheet 2 (in other
words, the values that are NOT in sheet one).


Thanks!

 

[CLR]

Put this in Sheet2 cell B1 and copy down

=IF(ISNA(VLOOKUP(A1,Sheet1!A1,1,FALSE)),A1,"")

Vaya con Dios,
Chuck, CABGx3

 

[Gary''s Student]

We can still use VLOOKUP() sort of in reverse.

Say the big list is in Sheet2 column A. Enter:

=VLOOKUP(A1,Sheet1!A1:A100,1,FALSE) and copy down. Formulas returning #N/A
correspond to names not found in Sheet1

 

[CLR]

My bad......
should have been

=IF(ISNA(VLOOKUP(A1,Sheet1!A:A,1,FALSE)),A1,"")

Vaya con Dios,
Chuck, CABGx3

 

[Jacob Skaria]

In sheet2 cell B1 apply the below formula and copy down as required...Will
return names which are not there in Sheet1 ColA.

=IF(COUNTIF(Sheet1!A:A,A1),"",A1)

OR ' handling blank entries in ColA

=IF(OR(A1="",COUNTIF(Sheet1!A:A,A1)),"",A1)

 

[MMcGee]

Thanks so much to everyone for your help! It appears that Mr. Skaria's
formula solved my problem. Thanks again kind sir!

Regards