Dynamic reference to cell =A1 -> =A(B2)

AndyD · Guest

Hi guys,

I wonder whether there is an easy way to reference a cell according to another cells value.
Meaning I would like to change the fixed refence of a cell, e.g.

=Table3.A10

to
=Table3.A(Table1.A2)

Trying to explain: Substitute the fixed row-reference "10" with the value of the field Table1.A2. Is that understandable?

I have no clue, but lots of pressure with a sheet that I have to finish _*now*_ so I would be very grateful for any help!

Thanks
Andy

Guest · Posted: Wed Jan 07, 2004 5:33 am Post subject: indirect() is my friend

Well, found the answer myself, perhaps useful for others:

Functions indirect() allows dynamic reference. In the German Version use Indirekt().

Cheers
Andy