Need help looking up data-vlookup isn't working
 

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!

Need help looking up data-vlookup isn't working
 

Put this in Sheet2 cell B1 and copy down

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

Vaya con Dios,
Chuck, CABGx3



"MMcGee" wrote in message
...

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!

Need help looking up data-vlookup isn't working
 

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
--
Gary''s Student - gsnu201003


"MMcGee" wrote:


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!

Need help looking up data-vlookup isn't working
 

My bad......
should have been

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

Vaya con Dios,
Chuck, CABGx3




"CLR" wrote in message
...
Put this in Sheet2 cell B1 and copy down

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

Vaya con Dios,
Chuck, CABGx3



"MMcGee" wrote in message
...

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!

Need help looking up data-vlookup isn't working
 

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)

--
Jacob (MVP - Excel)


"MMcGee" wrote:


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!

Need help looking up data-vlookup isn't working
 

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

Regards

"Jacob Skaria" wrote:

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)

--
Jacob (MVP - Excel)


"MMcGee" wrote:


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!