I have a named array constant: REF_TEXT={"A1","D3","G5"}. Basically its a list of cell references in text form. I also have a named formula: REF_LIST=INDIRECT(REF_TEXT). My expectation is that REF_LIST will return an array of references, such that =INDEX(REF_LIST,1) will return the value in cell A1, =INDEX(REF_LIST,2) the value in cell D3, and so on. Instead, =INDEX(REF_TEXT,1) is the only formula call that works, returning the correct value. =INDEX(REF_LIST,2) and all that follow result in a #REF! error.

I'm not exactly sure why this does not work. Is there a way to get INDIRECT to behave the way I want it to, or is this just not possible?

Thanks.