Not sure what kind of "INDIRECT with dynamic named range", but I tried to break it down as per my understanding:
Name range A1:A2 as "ColumnA"
Name range B1:B2 as "ColumnB"
Now I have text "Column" in D3, "A" in E3 and "Column" in D4, "B" in E4
Start to test by combine D & E to create a name in text.
=D3&E3
Then
=INDIRECT(D3&E3)
Now it shows #VALUE
In fact, the underlying value is range of {1;2} (with 1 & 2 in A1 & A2) if try to hit F9
Now test more by:
=SUM(INDIRECT(D3&E3)) = 3
Does it seem INDIRECT work with name range?
Bookmarks