Cells & Rows
Posted by How to on January 15, 2002 6:58 AM
Hi all,
simple question:
is possible to assign a cell value as a cell row or column reference?
Like: =A9 --> =A(3*3)
Sorry, i'm a newbye......
Thanks
Posted by Mark W. on January 15, 2002 7:03 AM
=INDIRECT("A"&3*3)
Posted by My Way on January 15, 2002 7:12 AM
HI
I just tried it and this is what I came to:
cell value/formula
A9 9
D1 3
E1 3
F1 =e1+d1
g1 =TEXT(f1,0)
h1 =CONCATENATE("A",G1)
i1 =INDIRECT(H1)
Put this values in your worksheet and see if this is what your' looking for.
Posted by My Way on January 15, 2002 7:16 AM
Mark W, you're the one
