I am trying to simplify my google sheet with named ranges to not be driven nuts by the formulas I have built. I have named quite some ranges and now I am trying to replace the cell references, e.g. C22 with the named range cell name. So far I used INDEX, so INDEX(age,1), which has not been a great idea for what I want to achieve.
Unfortunately, when I use this in a formula that I want to "pull down" just as I would do with a traditional formula, which would return C23, C24, ... the index example stays the same and is not dynamic. What could I use instead of INDEX to make this happen?
Thanks a lot!
