How a cell can be addressed with variable file-column?
 

for example :
I have A1 value as "hello"

I define A2 = "A"
I define B2 = "1"
I wish that if I type in A3 the value =A2&B2
the value I see in the A3 cell were "hello", instead what I see is "A1"

Does anyone know if it is possible to address a cell (A1) by defining the
column and the file as variables contained in other cells (in my example A2
and A3)?

Thanks

Victor

How a cell can be addressed with variable file-column?
 

In A3: =INDIRECT(A2&B2)
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"thegreeneyes" wrote:
for example :
I have A1 value as "hello"

I define A2 = "A"
I define B2 = "1"
I wish that if I type in A3 the value =A2&B2
the value I see in the A3 cell were "hello", instead what I see is "A1"

Does anyone know if it is possible to address a cell (A1) by defining the
column and the file as variables contained in other cells (in my example A2
and A3)?

Thanks

Victor