use the vlookup formula. See Excel help on Vlookup.

--
Regards,
Tom Ogilvy


"Suncoast" wrote in message
oups.com...
I am trying to compare and update 2 Excel files.

Both files have the same information, product ID number and quantity.
I want to compare file 1 (master) with file 2 (updated). I want to
verify that the product ID numbers are the same, if so, then update the
quantity with the newer number.

Column A Column B
-------------------------------------
Product ID Quantity

12345 25

*Product ID & Quantity are headers, columns A & B are just for
reference.


I would like generate a new updated file in the original format

Thanks for any suggestions.
Harold