Morning all,

I have created a catalog price and stock updater with index match. Basically the new catalog has the formula to match the part numbers and update the prices irrespective of what order the catalog or pricelist is in.

for the part number
=INDEX($A:$A,MATCH(D3,$A:$A,0))
for the price
=INDEX($B:$B,MATCH(D3,$A:$A,0))
example.xlsx

There are 2 errors.
1 - when the part no longer appears on the pricelist
2 - when a new part appears on the pricelist

Could someone point me in the direction of what functions to use to solve this?

1 - when the part no longer appears on the pricelist, to return the part name from the old catalog with a 0 as stock
2 - when a new part appears on the pricelist, to return the new part name with its price and 1 as stock

I would appreciate a bit of direction as to what formulas could be used?
Many thanks
~W