Allow INDIRECT to work with dynamic names
Now that we have dynamic arrays, we can set up dynamic range names to define those dynamic ranges.
However, because INDIRECT doesn't work with dynamic names, we're limited in the ways we can use those dynamic names.
Please fix the INDIRECT function so that it works with dynamic names.
13
votes
Charley Kyd
shared this idea
1 comment
-
Malcolm
commented
I've made a separate recommendation about getting INDIRECT to work with DataTypes. Basically any reference that you can put in a cell which works in that cell should be able to be turned into text and wrapped in INDIRECT(() and it should still work