Compare two workbooks

[Baire]

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!

[FDibbins]

Assuming you want to test WB 1 against WB2 and have the results shown in WB1, use this, copied down - adjust ranges as needed...
=IFERROR(VLOOKUP(B2,'[workbook 2.xls]Sheet'!B$2:B$27,1,FALSE),"Unavalable")

if you want it the other way, change the file name

[Baire]

This doesn't seem to work: I get the same result ("unavailable") in all cells.

[FDibbins]

it worked fine for me. take a look at the attached...

[Baire]

My bad! Selected both column A & B as matrix in the VLOOKUP ...