I have a workbook called profit2021.xls
I am trying to combine the indirect function to refer to the value on sheet which I have listed in E1
I get a message there is a problem with this formula
It would be appreciated if someone could kindly amend my formula
![]()
="[profit2021.xls"&indirect("'"&e1"'"&"!"&"$C$520")
Bookmarks