View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Hal Hal is offline
external usenet poster
 
Posts: 19
Default Compare Old & New Product List (i.e. VLOOKUP)

Hello,

Once a week I receive an updated price list from our supplier reflecting
newly added products, deleted products, and new pricing for certain products
in an Excel spreadsheet format. The list consists of approx. 1,500
products.

Is there a way to compare the Old list with the New one and somehow identify
the new changes in a few quick steps? Someone mentioned using "VLOOKUP" but
I'm not too familiar with it. Any help will be greatly appreciated.

Thank you in advance.

cww