Forum Discussion
jolietjmob
Jul 17, 2022Copper Contributor
Return cell contents of cell in different column but same row as reference cell.
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
- Riny_van_EekelenPlatinum Contributor