Cell reference manipulation
 

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.

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.

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.

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.


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