Using result from ADDRESS function as a cell reference itself

B

Bob Phillips

Something like =INDIRECT(ADDRESS(1,2)) ?

--

HTH

RP
(remove nothere from the email address if mailing direct)


LShutzberg said:
How can I use the result from a ADDRESS function as a cell reference
Click to expand...
itself?
 
H

Harlan Grove

Bob Phillips said:
Something like =INDIRECT(ADDRESS(1,2)) ?
Click to expand...
....

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)


Harlan Grove said:
Bob Phillips said:
Something like =INDIRECT(ADDRESS(1,2)) ?
Click to expand...
...

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.
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel - Wich Function should I use? 1
Merging from an Excel file with graphics 1
VB Script reference cells for in current table? 1
get a cell reference as a result of an If Function 1
Index Match & #values 0
OneNote and MS Forms 0
cell.address gives strange result 1
IF function says too many nested 1

Top