Need help looking up data-vlookup isn't working

  • Thread starter Thread starter MMcGee
  • Start date Start date
M

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!
 
Put this in Sheet2 cell B1 and copy down

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

Vaya con Dios,
Chuck, CABGx3
 
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
 
My bad......
should have been

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

Vaya con Dios,
Chuck, CABGx3
 
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)
 
Thanks so much to everyone for your help! It appears that Mr. Skaria's
formula solved my problem. Thanks again kind sir!

Regards
 
Back
Top