can INDEX use indirect?

[imported_unknown]

i have a cell on a worksheet that is created from a list that is defined on another worksheet. this cell (when selected) contains a named array. i am trying to indirectly copy data from this array to the current worksheet, but have had no success and may be going about this incorrectly.

i.e., worksheet1 has 30 named rectangular arrays on it. worksheet2 has a work area that should display one of these arrays based on selecting the arrayname from the list data in a cell. when i use [=INDEX(INDIRECT("a1"),1,1)] where A1 contains the defined arrayname, I cannot retrieve data from the array...it only retrieves the data from the current worksheet. i have also tried replacing INDIRECT with [=CELL("contents",A1)] and get the same error(s).

can INDEX use an arrayname reference that is not explicitly defined, or do i misunderstand the function?

thanks in advance for your help.

 

[Aladin Akyurek]

=INDEX(INDIRECT($A$1),ROW(1:1),1)

where A1 houses a named range like List.

The formula copied down will pull over all values from the first column of List.