Compare values in 2 different columns in 2 different workbooks and list differences

[Lisa65]

I have workbook1 column b that contains shipping numbers and I need to compare it to workbook2 column c which also has shipping numbers. Basically we are trying to ensure that the shipping numbers in workbook1 column b are contained in workbook2 column c and match exactly. If not, then we need to see what is missing. We generate workbook2 and our customer sends us workbook1. We'd like to find a way to automate this as much as possible as it will need to be done several times a week with changing data. Thanks.

 

[ravishankar]

You can insert this formula on to a blank column of a book and suitably adjust column names and rows and file names. and drag it down to the last row

=IF(ISERROR(MATCH(C2,'
[list files.xlsm]Sheet2'!$B$16:$B$28,0)),"missing",MATCH(C2,'
[list files.xlsm]Sheet2'!$B$16:$B$28,0))

Ravi shankar