StaceyVECL
New Member
- Joined
- Apr 13, 2022
- Messages
- 32
- Office Version
- 365
- Platform
- Windows
Hi everyone,
I have excel spreadsheets saved in a shared dropbox folder so that myself and colleagues can access and update. I have entered formulas to pull in information however its looking on my C drive which obviously returns an error when a colleague opens the spreadsheet.
Current formula using: =IF(B410="","",(VLOOKUP(@$B$398:$B$500,'C:\Users\User\DROPBOXFOLDER\[Shipment Details.xlsx]RM Formulas'!$E$1:$S$550,4,FALSE)))
The formula works for me but returns #N/A for colleagues. Is there a way to use Dropbox files without looking at the C drive? I have searched online and can't find anything useful.
Thanks in advance. Stacey.
I have excel spreadsheets saved in a shared dropbox folder so that myself and colleagues can access and update. I have entered formulas to pull in information however its looking on my C drive which obviously returns an error when a colleague opens the spreadsheet.
Current formula using: =IF(B410="","",(VLOOKUP(@$B$398:$B$500,'C:\Users\User\DROPBOXFOLDER\[Shipment Details.xlsx]RM Formulas'!$E$1:$S$550,4,FALSE)))
The formula works for me but returns #N/A for colleagues. Is there a way to use Dropbox files without looking at the C drive? I have searched online and can't find anything useful.
Thanks in advance. Stacey.