View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
gueyo gueyo is offline
external usenet poster
 
Posts: 17
Default Vlookup Question

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