Return data from a cell in a linked worksheet

%3CLINGO-SUB%20id%3D%22lingo-sub-2970442%22%20slang%3D%22en-US%22%3EReturn%20data%20from%20a%20cell%20in%20a%20linked%20worksheet%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2970442%22%20slang%3D%22en-US%22%3E%3CP%3EHi.%26nbsp%3B%20I%20have%20a%20worksheet%20that%20has%20links%20to%20other%20sheets%20within%20the%20workbook.%26nbsp%3B%20Let's%20say%20Sheet%201%20has%20a%20cell%20with%20a%20link%20to%20Sheet%202.%26nbsp%3B%20How%20do%20I%20return%20a%20value%20of%20a%20cell%20in%20Sheet%202%20into%20Sheet%20A1%20by%20referencing%20Sheet%201's%20linked%20cell%20address%3F%26nbsp%3B%20Basically%20a%20%22go%20to%20sheet%202%20and%20return%20the%20value%20of%20g31%22.%26nbsp%3B%20Thanks%20in%20advance.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2970442%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2970476%22%20slang%3D%22en-US%22%3ERe%3A%20Return%20data%20from%20a%20cell%20in%20a%20linked%20worksheet%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2970476%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1214210%22%20target%3D%22_blank%22%3E%40Ron_Westmoreland%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3DINDIRECT(%22'%22%20%26amp%3B%20C1%20%26amp%3B%20%22'!%22%20%26amp%3B%20D1%20%26amp%3B%20E1)%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EWith%20this%20formula%20you%20can%20dynamically%20enter%20sheet%20name%20in%20cell%20C1%20and%20column%20number%20in%20D1%20and%20row%20number%20in%20E1.%20In%20your%20example%20enter%20%22Sheet%202%22%20in%20C1%20and%20%22G%22%20in%20cell%20D1%20and%20%2231%22%20in%20cell%20E1.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2970506%22%20slang%3D%22en-US%22%3ERe%3A%20Return%20data%20from%20a%20cell%20in%20a%20linked%20worksheet%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2970506%22%20slang%3D%22en-US%22%3EThanks%20so%20much%20for%20the%20quick%20reply.%20Where%20in%20this%20formula%20does%20it%20reference%20the%20cell%20in%20Sheet%201%20that%20I%20want%20to%20point%20to%2C%20that%20contains%20the%20link%20to%20Sheet%202%3F%20Would%20that%20reference%20be%20in%20your%20%22C1%22%3F%20Thanks.%3C%2FLINGO-BODY%3E
Occasional Contributor

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.

3 Replies

@Ron_Westmoreland 

=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.
Also, which may complicate it further, the cell that references "Sheet 2" is a value returned from a filter.