Problems with Named Ranges and Indirect fundtion

[govuser]

Hello

Just to start off I used an indirect function to create a named range.
https://dc2.safesync.com/DzVrPJm/NamedRanges.xlsx?a=SqhACDyeGNo

I am having problems with named ranges where I am referencing a cell with the name of a named range via the indirect function but it is not picking it up. I think the reason is because of the way I referenced the range.

I would be grateful if someone could help with this query.

Test is name of array
G6 and G7 contain name of array 'Test'

=INDEX(Test,1,2) WORKS
=INDEX(G6,1,2) DOES NOT WORK
=INDEX(INDIRECT(G7),1,2) DOES NOT WORK

I feel the problem may be in the way I named the range

I used the name range function but used
=INDIRECT(Sheet1!$G$3)

Cell G3 contains the reference to the array A3:B6

The reason i did this is because I have 18 much larger datasets which I have used to create named ranges via this way. Grateful for any kind of help!

 

[Jonmo1]

Why not skip the named range then

If you're putting the Text string A3:B6 in G3, then just reference that with indirect..

=INDEX(INDIRECT(G3),1,2)


I think the trouble may be with the double indirect reference..
Indirect referencing another range that was created with Indirect..

 

[Jonmo1]

Here's the bottom line..
It's not so much that the named range was created with Indirect...

Indirect can't reference a dynamic named range.

It would only work if the Named Range (Test) was a straight A1 style reference.
=Sheet1!$A$3:$B$6