LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 2,059
Default How to use union reference operator?

Why doesn't the union reference operator work below?

Suppose J24:J28 contains 11,20,31,43,53, and K24:K28 contains the text
grp1,grp2,grp3,grp4,grp5.

And suppose A1 contains a value = 11, e.g. 24. I can use the following
formula to convert A1 to a category in K24:K28:

=index(K24:K28,match(A1,J24:J28))

But now suppose that I want to convert A1 to every other category, as if the
lookup ranges contained 11,31,53 and grp1,grp3,grp5.

Based on the help page "about calculation operators", I thought I could
write:

=index((K24,K26,K28),match(A1,(J24,J26,J28))

But that returns an error (#N/A). Why doesn't the union reference operator
work as intended?

Please do not try to provide alternative formulations to solve the
particular example. It is only an example. I am just trying to understand
the union reference operator.

 
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
Reference an Operator from a cell with Sumproduct deeds Excel Worksheet Functions 4 April 25th 08 04:06 PM
Why doesnt union reference operator work with COUNTIF? joeu2004 Excel Discussion (Misc queries) 1 September 15th 07 09:59 AM
union range Curt Excel Discussion (Misc queries) 9 April 20th 07 02:32 PM
How to use a cell value as operator in a worksheet reference? JRP2003 Excel Worksheet Functions 2 August 14th 06 06:24 PM
Help w/ Union Queries Jenn Excel Discussion (Misc queries) 1 January 12th 05 01:07 AM


All times are GMT +1. The time now is 05:50 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"