Forum Discussion
Returning cell value in sheet referenced in another cell.
Hi, I'm very much a rookie with excel and was hoping someone can help with the following. I'm trying to return the value of a cell from a sheet. As in the image below, I've simply put "=" then ...
You can use the INDIRECT function for this, BUT (and this is a big BUT!) it will only work if all the workbooks referred to (1.xlsx etc.) is also open in Excel. If they are closed, the formula will return #REF!
In C3:
=INDIRECT("'["&B3&"]Sheet1'!C5")
Fill down.
Hi Hans,
The but is big unfortunately but I really appreciate the help! I may be able to open each as they're saved and essentially manually update it.
The but is big unfortunately but I really appreciate the help! I may be able to open each as they're saved and essentially manually update it.