Indirect reference
 

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. :confused:

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

Indirect reference
 

Hi

=INDIRECT("W2!A"&A1)

--
Regards

Roger Govier


"pimar" wrote in
message ...

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. :confused:

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

Indirect reference
 

Thanks very much, Roger...
*pimar


--
pimar
------------------------------------------------------------------------
pimar's Profile: http://www.excelforum.com/member.php...fo&userid=5386
View this thread: http://www.excelforum.com/showthread...hreadid=501090