Lookup cell reference ?

[sfer007]

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

 

[AlanY]

can try the offset() function

=offset('Workbook'!D2,0,11)

0 is to offset rows from 'Workbook'!D2, in your case 0, and
11 is to offset column, 11

 

[sfer007]

Thanks, much appreciated exactly what I needed