Linking cell through variable

E

ezil

Although this is simple task i stuck up with these
for eg. cell A1= 5 (variable), A5=10 and i need in
in cell b1= A(variable of a1) in this case it is A5 i.e 10
How to write formula or macro for this.
 
M

mcescher

Although this is simple task i stuck up with these
for eg. cell A1= 5 (variable), A5=10  and i need in
in cell b1= A(variable of a1)           in this case it is A5i.e 10
How to write formula or macro for this.
Click to expand...

Take a look at the INDIRECT function.

B1 = INDIRECT("A" & A1)

Chris M.
 
Top