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
__________________________