Hi, I have a workbook with dynamic named ranges. If I use = INDIRECT(A1&"_Name"), then it will fail #REF!, here A1&"_Name" gives the dynamic name.

I did some search on the internet and confirmed that INDIRECT() does not work for dynamic named ranges.

So what can I do for this case?