Difficult query?
 

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

Difficult query?
 

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

Difficult query?
 

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

"JE McGimpsey" wrote:

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

Difficult query?
 

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?


In article ,
Daniel - Sydney wrote:

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.