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.