CODEWITHSUNDEEP
google-sheetsformulas
Steve Rohde
Steve Rohde

Reputation: 41

How do I return a reference to the first element of a named range?

I'd like to return a reference to the first element (i.e. upper left cell) of a named range in a Google Sheet. I don't want the cell value itself, but rather, the reference "address" of the cell, preferably in A1 notation.

Upvotes: 4

Views: 1265

Answers (1)

Tom Sharpe
Tom Sharpe

Reputation: 34285

It depends what you want to do with it. You can get the actual address with

=address(row(NamedRange1),column(NamedRange1))

or just

=cell("address",NamedRange1)

but you can also use INDEX to get a reference which you can use in a formula e.g.

=sum(index(NamedRange1,1,1):index(NamedRange1,3,3))

to give the sum of the area between the first row and column and third row and column of the range.

Upvotes: 4

Related Questions