matching key fields between two workbooks and displaying info when

T

tukky142

Hi

I have two workbooks with the following info that should be the same - but I
know it isnt
Work book 1
Column A ColumnB
Op number EA100, Part number BAC100123
Op number EA100, Part number BAC100124
Op number EA100, Part number BAC100125

Workbook 2
Op number EA100, Part number BAC100123
As above
As above

I want to create a formula that compares the op number and then flags when
the part number is not the same.
 
G

Gary Brown

Use the vlookup function.
In Col C put a 'cheater formula' something like...
=IF(VLOOKUP(A1,[Book3]Sheet2!$A:$B,2,FALSE)<>B1,"Not the same!","")
--
HTH,
Gary Brown
[email protected]
If this post was helpful to you, please select ''YES'' at the bottom of the
post.
 
T

tukky142

Thanks for your help - I tried the formula and it matches the first part
number in column b1 for EA100 but then says B2 isnt a match when it is? Can
you help further

Gary Brown said:
Use the vlookup function.
In Col C put a 'cheater formula' something like...
=IF(VLOOKUP(A1,[Book3]Sheet2!$A:$B,2,FALSE)<>B1,"Not the same!","")
--
HTH,
Gary Brown
[email protected]
If this post was helpful to you, please select ''YES'' at the bottom of the
post.



tukky142 said:
Hi

I have two workbooks with the following info that should be the same - but I
know it isnt
Work book 1
Column A ColumnB
Op number EA100, Part number BAC100123
Op number EA100, Part number BAC100124
Op number EA100, Part number BAC100125

Workbook 2
Op number EA100, Part number BAC100123
As above
As above

I want to create a formula that compares the op number and then flags when
the part number is not the same.
Click to expand...
Click to expand...
 
Top