address function

F

flyingmeatball

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.
 
R

Richard Buttrey

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.
Click to expand...


=INDIRECT("B"&C1)

HTH
__
Richard Buttrey
Grappenhall, Cheshire, UK
__________________________
 
Top