Imbedding a tab reference into a formulae

%3CLINGO-SUB%20id%3D%22lingo-sub-2300181%22%20slang%3D%22en-US%22%3EImbedding%20a%20tab%20reference%20into%20a%20formulae%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2300181%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20everyone%2C%20hoping%20you%20can%20help%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20have%20a%20spreadsheet%20with%20multiple%20tabs%20and%20want%20to%20be%20able%20to%20let%20the%20user%20decide%20which%20tab%20to%20extract%20data%20from%20i.e.%20select%20a%20specfic%20cell%20from%20tab%26nbsp%3B%20Feb%2C%20Mar%20or%20Apr%20etc%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EUser%20types%20the%20tab%20they%20want%2C%20such%20as%20%22Feb%22%20into%20a%20cell%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20want%20the%20formula%20to%20then%20use%20this%20to%20select%20a%20specific%20cell%20(say%2C%20C3)%20from%20the%20worksheet%20they%20select%20(Feb)%3C%2FP%3E%3CP%3EWithout%20the%20user%20reference%20this%20is%20would%20simply%20be%20%3D%2B'Feb'!C3%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EBut%20I%20want%20the%20tab%20reference%20to%20be%20user%20defined%20through%20their%20entry%20into%20a%20cell%2C%20say%20A1%3C%2FP%3E%3CP%3ESo%20how%20do%20I%20embed%20this%20in%20the%20formula%3F%3C%2FP%3E%3CP%3EI've%20tried%20%2B%24A%241!C3%20or%26nbsp%3B%2B'%24A%241'!C3%20or%26nbsp%3B%2B%24A%241!C3%20where%20the%20user%20has%20to%20use%20commas%20around%20the%20tab%20reference%20i.e.%20'Feb'%26nbsp%3B%20all%20without%20success%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EMany%20thanks%20in%20advance%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2300181%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2300481%22%20slang%3D%22en-US%22%3ERe%3A%20Imbedding%20a%20tab%20reference%20into%20a%20formulae%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2300481%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1038980%22%20target%3D%22_blank%22%3E%40lambybutler%3C%2FA%3E%26nbsp%3BTry%20it%20this%20way%3A%3C%2FP%3E%3CPRE%20class%3D%22lia-code-sample%20language-excel%22%3E%3CCODE%3E%3DINDIRECT(%22'%22%26amp%3BA1%26amp%3B%22'!C3%22)%3C%2FCODE%3E%3C%2FPRE%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22Screenshot%202021-04-28%20at%2005.52.54.png%22%20style%3D%22width%3A%20362px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F276161iA68BF81FE07BA8A9%2Fimage-size%2Flarge%3Fv%3Dv2%26amp%3Bpx%3D999%22%20role%3D%22button%22%20title%3D%22Screenshot%202021-04-28%20at%2005.52.54.png%22%20alt%3D%22Screenshot%202021-04-28%20at%2005.52.54.png%22%20%2F%3E%3C%2FSPAN%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2302773%22%20slang%3D%22en-US%22%3ERe%3A%20Imbedding%20a%20tab%20reference%20into%20a%20formulae%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2302773%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F403176%22%20target%3D%22_blank%22%3E%40Riny_van_Eekelen%3C%2FA%3E%26nbsp%3Bthat%20works%20just%20great.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EMany%2C%20many%20thanks%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor

Hi everyone, hoping you can help

 

I have a spreadsheet with multiple tabs and want to be able to let the user decide which tab to extract data from i.e. select a specfic cell from tab  Feb, Mar or Apr etc

 

User types the tab they want, such as "Feb" into a cell

 

I want the formula to then use this to select a specific cell (say, C3) from the worksheet they select (Feb)

Without the user reference this is would simply be =+'Feb'!C3 

 

But I want the tab reference to be user defined through their entry into a cell, say A1

So how do I embed this in the formula?

I've tried +$A$1!C3 or +'$A$1'!C3 or +$A$1!C3 where the user has to use commas around the tab reference i.e. 'Feb'  all without success

 

Many thanks in advance

3 Replies

@lambybutler Try it this way:

=INDIRECT("'"&A1&"'!C3")

Screenshot 2021-04-28 at 05.52.54.png 

@Riny_van_Eekelen that works just great. 

 

Many, many thanks

@lambybutler Great! Glad I could help.