Return cell contents of cell in different column but same row as reference cell.

Occasional Visitor

I have a workbook which has multiple worksheets.  The primary worksheet ('Summary'!) gathers info from the other sub-sheets.  A cell in the primary worksheet has the formula ='Allowance Calcs'!N55.  I am trying to create a formula which will return the contents of a cell in the same worksheet ('Allowance Calcs'!) and same row (55) however different column (X instead of N).

Can somebody help please?

1 Reply


If not simply 

='Allowance Calcs'!X55

you perhaps mean 

=OFFSET('Allowance Calcs'!N55,0,10)