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.
Thanks so much for the quick reply. Where in this formula does it reference the cell in Sheet 1 that I want to point to, that contains the link to Sheet 2? Would that reference be in your "C1"? Thanks.