Linking cell through variable

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

 

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

Take a look at the INDIRECT function.

B1 = INDIRECT("A" & A1)

Chris M.