L
LShutzberg
How can I use the result from a ADDRESS function as a cell reference itself?
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
B
Bob Phillips
Something like =INDIRECT(ADDRESS(1,2)) ?
--
HTH
RP
(remove nothere from the email address if mailing direct)
--
HTH
RP
(remove nothere from the email address if mailing direct)
itself?LShutzberg said:How can I use the result from a ADDRESS function as a cell reference
H
Harlan Grove
....Bob Phillips said:Something like =INDIRECT(ADDRESS(1,2)) ?
If so, either
=OFFSET($A$1,1-1,2-1) [or just =OFFSET($A$1,0,1)]
or
=INDIRECT("R"&1&"C"&2,0)
would be better because they use only one function call. INDIRECT(ADDRESS())
is never necessary. INDIRECT with derived R1C1 references could always be
used instead.
B
Bob Phillips
I agree, just tried to answer his question.
--
HTH
RP
(remove nothere from the email address if mailing direct)
--
HTH
RP
(remove nothere from the email address if mailing direct)
Harlan Grove said:...Bob Phillips said:Something like =INDIRECT(ADDRESS(1,2)) ?
If so, either
=OFFSET($A$1,1-1,2-1) [or just =OFFSET($A$1,0,1)]
or
=INDIRECT("R"&1&"C"&2,0)
would be better because they use only one function call. INDIRECT(ADDRESS())
is never necessary. INDIRECT with derived R1C1 references could always be
used instead.