Difficult query?

  • Thread starter Daniel - Sydney
  • Start date
D

Daniel - Sydney

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
 
J

JE McGimpsey

One way:

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

Daniel - Sydney

Thanks for helping but I must be doing something wrong, or did not explain
well enough.
The query is not working, I even did a cut and paste in case I was typing it
wrong.

thanks
 
J

JE McGimpsey

Without knowing what you mean by "not working", it's hard to know what
to suggest.

Are you getting an error? an incorrect result? a crash? something else?
 
Top