Yes, there probably is an easier way around this but that doesn't
solve my primary dilemma.

If (as you say )the Array constant in cell A1 is being treated as text
instead of an array, is there a way to force it to be treated as such.
Something like what the INDIRECT() function does for address strings?

S.



On Aug 27, 9:25*pm, Sean Timmons
wrote:
you are referencing values rather than hard-coding them. In this case, the
values are treated as text rather than an array. *There's usually an easier
way around this issue if you're trying to calculate something...

"Sean" wrote:
Maybe I'm missing a trick here.

The formula *=INDEX({1,2,3},1,2) will return the value 2

The formula *=INDEX(A1,1,2) where the cell A1 contains the array
constant ={1,2,3} will return a #REF! error

Why does this happen and what is wrong with referencing a array in a
cell?