Thread: ADDRESS Function as cell ref in equation
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Dave Peterson Dave Peterson is offline
external usenet poster
  
Posts: 35,218
Default ADDRESS Function as cell ref in equation
Put it inside =indirect().

=indirect("a1")
will always point to A1
=indirect(a1)
will point to the cell whose address is in A1.

=indirect(address(....

TheHat wrote:

The ADDRESS function returns a text string of a cell location; i.e. R17. How
can I use this output as a cell reference in an equation? I keep getting
#VALUE! errors.
--
Thanks,
TheHat

--

Dave Peterson
Reply With QuoteReply With Quote