My first cell, A2, is a simple return from another sheet i.e. ='Workbook'!D2.
In the cell below, A3, I want to look at the same row but 11 columns across e.g. ='Workbook'!O2
I need to do this for a number of cells below but don't want to manually enter each cell.
Is there a formula I can use that references the cell above + 11 columns?
Hope that makes sense.
Thanks, Scott
In the cell below, A3, I want to look at the same row but 11 columns across e.g. ='Workbook'!O2
I need to do this for a number of cells below but don't want to manually enter each cell.
Is there a formula I can use that references the cell above + 11 columns?
Hope that makes sense.
Thanks, Scott