Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Using result from ADDRESS function as a cell reference itself
How can I use the result from a ADDRESS function as a cell reference itself?
|
#2
|
|||
|
|||
Something like =INDIRECT(ADDRESS(1,2)) ?
-- HTH RP (remove nothere from the email address if mailing direct) "LShutzberg" wrote in message ... How can I use the result from a ADDRESS function as a cell reference itself? |
#3
|
|||
|
|||
"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. |
#4
|
|||
|
|||
I agree, just tried to answer his question.
-- HTH RP (remove nothere from the email address if mailing direct) "Harlan Grove" wrote in message ... "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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Maintaining cell reference after sorting | Excel Discussion (Misc queries) | |||
Amount or Numbers in Words | New Users to Excel | |||
GET.CELL | Excel Worksheet Functions | |||
name of another worksheet in cell for reference | Excel Worksheet Functions | |||
Can I use a cell reference in the criteria for the sumif function. | Excel Worksheet Functions |