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.