KWilkinson
New Member
- Joined
- Dec 9, 2016
- Messages
- 11
Hi all,
I have the following formula in a spreadsheet : =INDIRECT("'"&$F$12&"'!"&"O3")
This as expected returns the value in cell O3 of the sheet name defined in cell F12. So far so good.
However I want to be able to drag this formula down and each time have it reference the next cell down, i.e. O3, O4, O5 etc. Because the formula treats the O3 as a string (I think anyway) it doesn't change. So my question is is there a way to do this so that as the formula is copied down the target cell increases?
Many thanks in advance for any suggestions on this.
Cheers
K.
I have the following formula in a spreadsheet : =INDIRECT("'"&$F$12&"'!"&"O3")
This as expected returns the value in cell O3 of the sheet name defined in cell F12. So far so good.
However I want to be able to drag this formula down and each time have it reference the next cell down, i.e. O3, O4, O5 etc. Because the formula treats the O3 as a string (I think anyway) it doesn't change. So my question is is there a way to do this so that as the formula is copied down the target cell increases?
Many thanks in advance for any suggestions on this.
Cheers
K.