Compare two workbooks

Hi,

I've got two workbooks: both workbooks contain two columns (product_id and code). Workbook 1 is the original one, workbook 2 is an update of workbook 1 in which a number of product_id's are deleted. I want to know which product_id's are deleted and no longer available. Based upon that result I can set the status of a product to 0 (not available) or 1 (available) in (for example) a third column "status".

Can somebody help me out?

Thx!