Indirect reference


P

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

Any help?
thanks
*pimar
 
Ad

Advertisements

Ad

Advertisements


Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top