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!