Remember Me?

#1
December 11th 04, 04:37 PM
 LShutzberg Posts: n/a
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
December 11th 04, 04:54 PM
 Bob Phillips Posts: n/a

--

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
December 12th 04, 06:15 AM
 Harlan Grove Posts: n/a

"Bob Phillips" wrote...

....

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

#4
December 12th 04, 11:18 AM
 Bob Phillips Posts: n/a

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...

...

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.

is never necessary. INDIRECT with derived R1C1 references could always be

 Posting Rules Smilies are On [IMG] code is On HTML code is OffTrackbacks are On Pingbacks are On Refbacks are On

 Similar Threads Thread Thread Starter Forum Replies Last Post ron New Users to Excel 6 December 24th 04 07:32 PM GRITS Excel Discussion (Misc queries) 1 December 2nd 04 08:30 PM Biff Excel Worksheet Functions 2 November 24th 04 07:16 PM Tom A Johnson Excel Worksheet Functions 2 November 11th 04 11:28 PM Number Cruncher Excel Worksheet Functions 2 November 4th 04 07:52 PM

All times are GMT +1. The time now is 05:49 AM.