Comparing data in two workbooks

  • Thread starter Thread starter Erwin
  • Start date Start date
E

Erwin

Old price book in Workbook A.

New price book in Workbook B.

How do I find, and return to a new workbook, the part numbers that are in
workbook B but not A.

Thanks in advance.
 
Assuming your PartNumbers in Workbooks A and B are all on Sheets1, and are
all in Column A, I would open a new Workbook C and then open A and B and
copy Sheet1 of Workbook B to Sheet2 of Workbook C and copy Sheet1 of
Workbook A to Sheet 3 of Workbook C.

Then in Sheet1 of Workbook C in cell A1, put this formula and copy down (all
one line, watch out for email wordwrap)

=IF(ISNA(VLOOKUP(Sheet2!A1,Sheet3!A:A,1,FALSE)),Sheet2!A1,IF(VLOOKUP(Sheet2!
A1,Sheet3!A:A,1,FALSE)=Sheet2!A1,"both"))

Then Column A will list all the PartNumbers found only on list B, and show
"both" if the Partnumber shows on both lists.

Vaya con Dios,
Chuck, CABGx3
 
Back
Top