If original sheet is named 'Sheet1' then put this in C1 of the new sheet
=IF(VLOOKUP(A1,Sheet1!A:B,2,False)=B1,"",VLOOKUP(A 1,Sheet1!A:B,2,False))

It will return
a blank if values match
original price if values don't match
and #N/A if value is not found

"gueyo" wrote:

I have two wooksheets. The first is the original sheet that has part numbers
with pricing. This needs to be loaded into my database. Once done I need to
generate a new list from the database and check it back to the original to
make sure the pricing is coming in correctly. If pricing is not matching I
need to have that marked somehow.

So if I have original
RUL 24 4.99
RUL 25D 14.99
RUL 26D 18.54

and New worksheet has
RUL 24 9.99
RUL 25D 14.99
RUL 26D 18.54

It will tell me that RUL24 pricing is different. At the same time I need to
know if any numbers from the original worksheet is missing from the new
worksheet.
So it's like two formulas in one.

Thank you
--
gueyo