Hi
Have a look at the INDIRECT function. Sorry I can't help more but my Excel
is busy recalculating a rather large sheet!
--
Andy.


"RwenglerMN" wrote in message
...
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.