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)

--
Regards

Roger Govier


"pimar" <[email protected]> wrote in
message news:[email protected]...
>
> 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
>
>
> --
> pimar
> ------------------------------------------------------------------------
> pimar's Profile:
> http://www.excelforum.com/member.php...fo&userid=5386
> View this thread:
> http://www.excelforum.com/showthread...hreadid=501090
>

[pimar]

Thanks very much, Roger...
*pimar