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



"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!

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!

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!

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!

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!