Ok I have sort of solved this problem and thought I would share the
love so to speak. What I did eventually was merge the 2 datain the
columns in worksheet1 in the next column using something like
=A2&" "&B2
if you don't want spaces use =A2&B2
I did the same on the worksheet two and then used this formula to look
for duplicates
=IF(ISNA(VLOOKUP(C2,Sheet4!$C$2:$C$14,1,0)),"no match", "match")

hope this helps others.