"Bob Phillips" wrote...
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.
|