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 ...
Slightly modified formula suggested by HansVogelaar if get value from the same cell in another workbook
=INDIRECT("'[" & $B3 & "]Sheet1'!" & CELL("address"))
If to keep all files opened is not the case perhaps it could be workaround with VBA or Power Query.
- Much appreciated, I've only just heard of power query but seems like there will be lots of uses so will definitely look into that!
