Forum Discussion
Solved
Extracting a text from one cell to reference another sheet
Hello! I'm trying to extract information from a different sheet within the same workbook. When looking at the attached example in the images below, the simple equation I would use is... =Clevelan...
=INDIRECT("'"&E3&"'!"&E2)
Maybe with this formula. You can dynamically enter the sheetname in E3 and the cell in E2.
=INDIRECT("'"&E3&"'!"&E2)
Maybe with this formula. You can dynamically enter the sheetname in E3 and the cell in E2.
This worked perfectly for what I needed to do! Thank you so much for the help!