Compare Old & New Product List (i.e. VLOOKUP)
As a start:
Assume Oldlist and Newlist are in Column A of sheets 1 & 2 and OldPriceList
is Column B of sheet1.
Highlight column A sheet1 and do Insert==Name==Define==Oldlist
Highlight column B sheet1 and do Insert==Name==Define==OldPricelist
Highlight column A sheet2 and do Insert==Name==Define==Newlist
Assuming data starts in row 1:
In C1 of Sheet1 put =IF(COUNTIF(Newlist,A1)=0,"Deleted","") and copy down
This will highlight producs Deleted
in C1 of sheet2 put =IF(COUNTIF(OldList,A1)=0,"Added","") and copy down
This will highlight products Added
For products which have price changes:
In D1 of sheet2 put:
=IF(ISERROR(MATCH(A1,OldList,0)),"",IF(INDEX(OldPr iceList,MATCH(A1,OldList,0))<B1,"Price Changed",""))
and copy down
HTH
"Hal" wrote:
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
|