Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss
How do you dereference a cell's text address?
2,584 views
Skip to first unread message
Ted
Jun 5, 2002, 10:41:55 AM6/5/02
to
I use the ADDRESS() function to prepare a cell address.
Now how do I actually reference that cell?! I.e., in a
formula I want to use the value in that cell reference,
not the reference itself. Must be obvious, but can't find
anything in Excel Help.
Now how do I actually reference that cell?! I.e., in a
formula I want to use the value in that cell reference,
not the reference itself. Must be obvious, but can't find
anything in Excel Help.
= DEREFERENCE( ADDRESS(...) )
Thanks!
J.E. McGimpsey
Jun 5, 2002, 10:56:41 AM6/5/02
to
Try:
=INDIRECT(ADDRESS(...))
In article <a7b201c20c9f$23c0b380$36ef2ecf@tkmsftngxa12>, Ted
Jason Morin
Jun 5, 2002, 10:56:24 AM6/5/02
to
Try:
=INDIRECT(ADDRESS(.....))
HTH
Jason
Atlanta, GA
>.
>
Tim Zych
Jun 5, 2002, 10:59:52 AM6/5/02
to
=INDIRECT(ADDRESS(...))
"Ted" <ted...@yahoo.com> wrote in message
news:a7b201c20c9f$23c0b380$36ef2ecf@tkmsftngxa12...
Harlan Grove
Jun 6, 2002, 1:28:53 PM6/6/02
to
Ted <ted...@yahoo.com> wrote...
Don't bother unless you're using the sheetname argument to ADDRESS. You've
already been told to use INDIRECT(ADDRESS(...)), but OFFSET may be more
efficient, and would certainly involve one fewer level of nested function
calls.
=INDIRECT(ADDRESS(r,c)) <==> =OFFSET($A$1,r-1,c-1)
0 new messages