Forum Discussion
keriblueberry
May 31, 2020Copper Contributor
Variable Sheet Name in Function
How do I express ='sheetname'!A1 when the sheet name is variable?
1 Reply
- hynguyenIron Contributor
keriblueberry You can consider to use Indirect function. Useful explanation on how to use it could be found here https://www.contextures.com/xlFunctions05.html