(#REF! ) Error using Indirect Function with Named Range built on Index Function

[ma7ros4ever]

In Excel 365,

I have a named range in Names Manager Named => Wire1 ,

Wire1 = INDEX($A$8:$H$10000,20*2+1,1):INDEX($A$8:$H$10000,3*20,8) ,

In Cell A1 I Typed Wire1 as a text not formula ,

In Cell A2 I want to spill the Array of the named range Wire1 by reading its name from cell A1.

In Cell A2 I typed formula = INDIRECT(A1) but it gave me #REF!

Please advice.

 

[RoryA]

INDIRECT is quite particular about what it will accept. It doesn't like anything other than a literal address string or the name of a direct (not calculated) range reference in my experience.

 

[ma7ros4ever]

Is there an alternative for indirect
for example look up cell A1 in the name manager and returns the array?

 

[RoryA]

Not without macros (either VBA or XLM).