Nov 16 2021 06:31 AM
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 referencing Sheet 1's linked cell address? Basically a "go to sheet 2 and return the value of g31". Thanks in advance.
Nov 16 2021 06:37 AM
=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.
Nov 16 2021 06:45 AM
Nov 16 2021 06:48 AM