Question

[Just Merks]

Seems a simple question, but I do not have a clue.

Assume in Cell A1 "= A2".

Now I want to reffer the two with a value which is in A3. Which can vary.

Something like "=A(A3)"

Is that possible?

 

[Claus Busch]

Hi Just,

Am Fri, 22 Jul 2011 20:43:00 +0200 schrieb Just Merks:

Assume in Cell A1 "= A2".
Now I want to reffer the two with a value which is in A3. Which can vary.
Something like "=A(A3)"

try:
=INDIRECT("A"&A3)


Regards
Claus Busch