One way:

E1: =IF(ISNA(MATCH(C1, A:A, FALSE)), "", IF(VLOOKUP(C1, A:B, 2,
FALSE)=D1, "", "Different"))

In article ,
Daniel - Sydney wrote:

Hi

I have a really hard one and hope I can explain it.
I am using XL 2002 SP3

I have two sets of two columns. In each case,
in column A is a list of code, column B shows the product name,
the second set of columns have the same type of list, but not exactly the
same content.
Some of the products in column B of the second pair of Columns have the
wrong product name.

Is it possible to do a query where if the codes in columns A are the same
but the adjacent name in column B is not, it is highlighted in some way.

I can put the second two columns into the same spreadsheet making them A, B,
C and D.
Please note that the codes will not be aligned as the lists are not complete
duplicates.

I hope you understand this and someone can help.

thanks