evaluate cell address

[chris]

I want to come up with the value of a cell dynamically.
given:
a1 = 5
a5 = 100
i want a function that will give me the value of cell a5.

what I have so far is

=address(a1,1) which gives me the result $a$5

what can I use to evaluate that result as a cell
reference?
ie.
=unknownFunction(address(a1,1)) gives the value 100

thanks for any help!!!

 

[Frank Kabel]

Hi
use INDIRECT. e.g.
=INDIRECT("A" & A1)