Use
=INDIRECT("B"&A1)
Duke
"RwenglerMN" wrote:
Is there a way to use a formula to dictate a cell reference?
eg. if cell A1=2 then =B(A1) would reference cell B2?
I saw someone else with a similiar question, but saw no posted answer.
I suspect it may be possible in R1C1 cell reference mode.
|