The Power of Named Ranges in Google Sheets [2024]

[@ChristopherPhillipsDev]

Is it possible to have a relative named range? For example, I have cell C13 as named range "row_id". If I reference row_id in the same row but a different column, that's fine. But if I change to a different row, I'd like the named range to reference the new row.

[@dataful-tech]

Sort of, not sure if it covers your use case. For example, you can name a range C1:C20 as "data". Then you can refer to it in D1 as '=data' and you will get the value from C1. Same reference in D2 will give you C2, and so on. It also works in other sheets: you will get the value from row X that is a part of a named range when referring it from row X. Note: it works only if your range has one column. You will get an error otherwise. Does it make sense to you?

[@ChristopherPhillipsDev]

@@dataful-tech Yes, thank you! That did the trick. Subbed!