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

If this post was helpful to you, please select ''YES'' at the bottom of the
post.



"tukky142" wrote:

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.