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

Lisa65

New Member
Joined
Oct 4, 2018
Messages
1
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.
 

Some videos you may like

Excel Facts

Add Bullets to Range
Select range. Press Ctrl+1. On Number tab, choose Custom. Type Alt+7 then space then @ sign (using 7 on numeric keypad)

ravishankar

Well-known Member
Joined
Feb 23, 2006
Messages
3,566
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
 
Last edited:

Watch MrExcel Video

Forum statistics

Threads
1,089,862
Messages
5,410,855
Members
403,331
Latest member
dignityy

This Week's Hot Topics

Top