tonywatsonhelp
Well-known Member
- Joined
- Feb 24, 2014
- Messages
- 3,194
- Office Version
- 365
- 2019
- 2016
- Platform
- Windows
Hi Everyone,
Currently in cell H2 I have the following formula
=SUM('https://hcr.sharepoint.com/sites/Finance/Shared Documents/Finance - Confidential/Accounts/Mgmt Accounts/Project Reports/2022_Proj/21122001/[21122001_Dashboard.xlsm]Sales'!$G:$G)
which works great at pulling in a figure from this other sheet.
What I want to do is instead of having the number "21122001" in the formula, have it in cell B2 and look it up, but everything I'm trying doesn't seam to work,
any ideas how i could get this to work?
Thanks
Tony
Currently in cell H2 I have the following formula
=SUM('https://hcr.sharepoint.com/sites/Finance/Shared Documents/Finance - Confidential/Accounts/Mgmt Accounts/Project Reports/2022_Proj/21122001/[21122001_Dashboard.xlsm]Sales'!$G:$G)
which works great at pulling in a figure from this other sheet.
What I want to do is instead of having the number "21122001" in the formula, have it in cell B2 and look it up, but everything I'm trying doesn't seam to work,
any ideas how i could get this to work?
Thanks
Tony