address function
 

I know with the address function I can turn references into text, but is
there a way to do the opposite? In other words, I know I need to
reference cell BX, where X is the value stored in cell C1.


--
flyingmeatball
------------------------------------------------------------------------
flyingmeatball's Profile: http://www.excelforum.com/member.php...o&userid=37302
View this thread: http://www.excelforum.com/showthread...hreadid=572648

address function
 

On Thu, 17 Aug 2006 10:29:38 -0400, flyingmeatball
<flyingmeatball.2couo5_1155825014.4027@excelforu m-nospam.com wrote:


I know with the address function I can turn references into text, but is
there a way to do the opposite? In other words, I know I need to
reference cell BX, where X is the value stored in cell C1.


=INDIRECT("B"&C1)

HTH
__
Richard Buttrey
Grappenhall, Cheshire, UK
__________________________