MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Range name reference in formula

Posted by Eric on November 08, 2000 1:34 PM

I have drop down boxes that when concatenated form 2111. I have a range which I've named _2111 and I want to use the formula =index(_2111,1,1). If my concatenation is in cell A1, how can I make something like =index(A1,1,1) work?

Posted by AB on November 09, 2000 7:09 AM

=INDEX(INDIRECT("_" & A1),1,1)

=INDEX(INDIRECT("_" & A1),1,1)