I currently have the following formula;
=OFFSET(Sheet1$A$1,Sheet2!$A$2,0)
I'm doing this so I'm moving down by the number of cells stored in the value of the cell Sheet2!$A$2. All good and works perfectly.
Now I basically I am copying this formula for other rows etc
=OFFSET(Sheet1$A$1,Sheet2!$A$2,0)
=OFFSET(Sheet1$A$1,Sheet2!$A$3,0)
=OFFSET(Sheet1$A$1,Sheet2!$A$4,0)
As you can see i'm wanting the value in Sheet2!$A$X to increase by a value. Now its not necessary by 1. I want this to increase by a value set in another cell. So it references the Sheet2!$A$<cell> Is this possible?
So just said I have value of 1 in cell A2
I want my formula's to be;
=OFFSET(Sheet1$A$1,Sheet2!$A$1,0)
=OFFSET(Sheet1$A$1,Sheet2!$A$1,0)
=OFFSET(Sheet1$A$1,Sheet2!$A$1,0)
So it still refers to the Sheet2!$A$1 or say Sheet2!A$2 if the value in A2 = 2, or Sheet2!A$3 if the value in A2 = 3.
Hope this makes sense, can anyone please help?
Bookmarks