indirection or something similar

[Simon Hart]

Hi folks.

Trying to work out how to do this but I'm blowed if I can. What I'm after is
"this cell is set to the contents of another cell that is referenced as,
say, B(3+A2), where (3+A2) is "3 plus the contents of A2". E.g. if the cell
A1 has something like "=B(3+A2)" in it and A2 has say "27" in it then A1
will be set to the value contained in A30. The idea being that as you change
A2 then A1 will change dynamically with it. This is actually going to be
used to get values form another workbook.

Regards,

Simon.

 

[Max]

Think you're after INDIRECT() ..

If you have

In A2: 3
In B6: 78

and you put in A1: =INDIRECT("B"&(3+A2))

A1 will return the contents of cell B6, i.e. 78

 

[Earl Kiosterud]

Simon,

=OFFSET(B1,2+A2,0)