Forum Discussion
Return data from a cell in a linked worksheet
Hi. I have a worksheet that has links to other sheets within the workbook. Let's say Sheet 1 has a cell with a link to Sheet 2. How do I return a value of a cell in Sheet 2 into Sheet A1 by refere...
=INDIRECT("'" & C1 & "'!" & D1 & E1)
With this formula you can dynamically enter sheet name in cell C1 and column number in D1 and row number in E1. In your example enter "Sheet 2" in C1 and "G" in cell D1 and "31" in cell E1.
Also, which may complicate it further, the cell that references "Sheet 2" is a value returned from a filter.