Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old December 11th 04, 04:37 PM
LShutzberg
 
Posts: n/a
Default 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   Report Post  
Old December 11th 04, 04:54 PM
Bob Phillips
 
Posts: n/a
Default

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

"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   Report Post  
Old December 12th 04, 11:18 AM
Bob Phillips
 
Posts: n/a
Default

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Amount or Numbers in Words ron New Users to Excel 6 December 24th 04 07:32 PM
Maintaining cell reference after sorting GRITS Excel Discussion (Misc queries) 1 December 2nd 04 08:30 PM
GET.CELL Biff Excel Worksheet Functions 2 November 24th 04 07:16 PM
name of another worksheet in cell for reference Tom A Johnson Excel Worksheet Functions 2 November 11th 04 11:28 PM
Can I use a cell reference in the criteria for the sumif function. Number Cruncher Excel Worksheet Functions 2 November 4th 04 07:52 PM


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

Powered by vBulletin® Copyright ©2000 - 2021, Jelsoft Enterprises Ltd.
Copyright 2004-2021 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017