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
Please Login or Register to view this content.
=INDIRECT("[profit2021.xlsx]"&E1&"!"&"$C$520")
My General Rules if you want my help. Not aimed at any person in particular:
1. Please Make Requests not demands, none of us get paid here.
2. Check back on your post regularly. I will not return to a post after 4 days.
If it is not important to you then it definitely is not important to me.
Thanks for the help. Formula works perfectly
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks