Search code examples
google-sheetsindexinggoogle-sheets-formulaformulanamed-ranges

Google Sheets Named Range - reference single cell and enable pull-down

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!

Solution

  • try like this:

    =INDEX(age, ROW(A1))