#1   Report Post  
Posted to microsoft.public.excel.misc
Daniel - Sydney
 
Posts: n/a
Default 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
  #2   Report Post  
Posted to microsoft.public.excel.misc
JE McGimpsey
 
Posts: n/a
Default 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

  #3   Report Post  
Posted to microsoft.public.excel.misc
Daniel - Sydney
 
Posts: n/a
Default 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


  #4   Report Post  
Posted to microsoft.public.excel.misc
JE McGimpsey
 
Posts: n/a
Default 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.

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
changing query source [email protected] Excel Worksheet Functions 2 March 21st 06 09:55 PM
AHHH! Again JAA149 Excel Discussion (Misc queries) 0 October 31st 05 12:36 PM
AHHHH-Get Data from Multiple Excel workbooks JAA149 Excel Discussion (Misc queries) 5 October 30th 05 06:19 PM
"Query cannot be edited by the Query Wizard" PancakeBatter Excel Discussion (Misc queries) 0 April 25th 05 06:59 PM
Difficult matrix query Krista F Excel Worksheet Functions 2 April 5th 05 10:11 PM


All times are GMT +1. The time now is 11:08 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"