In a spreadsheet, I've got a column named range: Sheet1!I:I
, named NamedRanged1
.
In another sheet, I'd like to get the index of that named range, i.e., 9 (I
is 9th column).
I tried with ADDRESS
and IMPORTRANGE
:
=ADDRESS(IMPORTRANGE("1TBLF4H6r7EpCBtbTaa9Yan986DnyC_7UhDIWAG5gQX8","Sheet1!A1:Z100"))
but without success.
Is there a function which can retrieve coordinates from the name of a named reference?
ADDRESS(ROW(Book1!NamedRanged1), COLUMN(Book1!NamedRanged1)) & ":" & ADDRESS(ROWS(Book1!NamedRanged1)+(ROW(Book1!NamedRanged1)-1), COLUMNS(Book1!NamedRanged1)+(COLUMN(Book1!NamedRanged1)-1))
.