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?