Variable Sheet Name in Function

%3CLINGO-SUB%20id%3D%22lingo-sub-1430023%22%20slang%3D%22en-US%22%3EVariable%20Sheet%20Name%20in%20Function%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1430023%22%20slang%3D%22en-US%22%3E%3CP%3EHow%20do%20I%20express%20%3CFONT%3E%3D'sheetname'!A1%20when%20the%20sheet%20name%20is%20variable%3F%3C%2FFONT%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1430023%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Highlighted
Occasional Visitor

How do I express ='sheetname'!A1 when the sheet name is variable?

1 Reply

@keriblueberry You can consider to use Indirect function. Useful explanation on how to use it could be found here https://www.contextures.com/xlFunctions05.htmlIndirect.pngIndirect2.png