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?