Cell reference manipulation

R

RwenglerMN

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

Guest

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

jiwolf

Yup. there are few ways to do it, depends really on what you are trying to
do. The INDIRECT function will do it, or, if you are trying to generate a
"moving track" then a litle HLOOKUP will do it.
 
Top