Indirect reference

[pimar]

Very basic question, sorry.

I have my nice spreadsheet with worksheet W1 and W2
In worksheet 2, I need to reference a cell in W1, depending from an
index that need to be specified by user in a cell in spreadsheet W2
For example:

cell value in W2.A1 is 1 - then in W2.B1 I need to reference cell
W1.A1

if cell value in W2.A1 changes in 2, then in W2.B1 I need to reference
cell W1.A2


I know I need to use the ADDRESS and INIDRECT function, but I'm not
able to find the right way.

Any help?
thanks
*pimar

 

[Roger Govier]

Hi

=INDIRECT("W2!A"&A1)

 

[pimar]

Thanks very much, Roger...
*pimar