LinkBack URL
About LinkBacks
In the formula below, what is the syntax to replace the reference to 'Lot Data' with a reference to a table on OneDrive titled 'RawHoneyLotData' and a tab named 'Current'?
=IFERROR(VLOOKUP(G5,'Lot Data'!$A$4:$R$121,5,FALSE)," ")
In the formula below, what is the syntax to replace the reference to 'Lot Data' with a reference to a table on OneDrive titled 'RawHoneyLotData' and a tab named 'Current'?
=IFERROR(VLOOKUP(G5,'Lot Data'!$A$4:$R$121,5,FALSE)," ")
Try creating that formula, and pointing to the range in the other file
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
I know how to point to the range in my other file. The help I need is the syntax and punctuation in my formula for the reference to the file on OneDrive.
I was pretty sure you did know how to do it, I just meant, if you did it that way, it might give you the path/syntax you need - same as if you referenced a different file on your HDD
I'm pretty sure the files in "OneDrive", or any other Cloud File Sharing product, ARE on the hard drive. The point of the OneDrive product is that it synchronises files that you put in the OneDrive folder. So, in that respect, you should be able to navigate to it.
You would have something like this:Formula:
Please Login or Register to view this content.
Trevor Shuttleworth - Retired Excel/VBA Consultant
I dream of a better world where chickens can cross the road without having their motives questioned
'Being unapologetic means never having to say you're sorry' John Cooper Clarke
Trevor, thanks for the input. I dont use OneDrive, but figured it would be something like that.
My pleasure.
Thanks for your input. That gets me headed in the right direction.
You're welcome.
If you are satisfied with the solution(s) provided, please mark your thread as Solved.
New quick method:
Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.
Or you can use this way:
How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save
You may also want to consider thanking those people who helped you by clicking on the little star at the bottom left of their reply to your question.
I never resolved this issue so after an 8 month rest I'm re-visiting the issue. My current VLOOKUP reads as follows:
=IFERROR(VLOOKUP($A8,'Lot Data'!$A$3:$N$149,5,FALSE)," ")
In the example above, my form and the worksheet 'Lot Data' are in the same workbook.
I want to change the reference to 'Lot Data' in the formula above to refer to a worksheet 'Current' in a different workbook on OneDrive at the path below:
https://onedrive.live.com/edit.aspx?...!111&app=Excel
Is this possible? If so, what is the syntax?
Dropbox Folders, in my experience, are located on the hard drive and Dropbox automatically syncs the folders and files with the cloud.
If you click on the Dropbox icon, then choose settings (cog, top right), select Preferences and then Sync, it will tell you where your Dropbox folder is.
Mine is under C:\Users\username\Dropbox
I do not know if you can access the Dropbox folder in the cloud.
However, you can make the Dropbox folder available to Microsoft Office in Settings | Preferences | General
Having made Dropbox visible, I recorded a macro whilst I saved a file to the Dropbox folder (and a subfolder within it)
This is what I got:
Again, it is going to the folder on the hard disc, not the cloud
Please Login or Register to view this content.
I don't see how using a Dropbox would work. The drop box would have to be in a location available to all users just as the file is on OneDrive so it will be available to all users.
I appreciate your help but I won't be working on this problem anymore. Thank you again.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks