Jul 17 2022 07:57 PM
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?
Jul 17 2022 09:10 PM
If not simply
='Allowance Calcs'!X55
you perhaps mean
=OFFSET('Allowance Calcs'!N55,0,10)