Hiya,
I'm trying to complete an IFERROR/VLOOKUP formula to pull information from a spreadsheet saved on OneDrive, to another spreadsheet saved locally.
I've done this before with no issues but Excel isn't liking the link...
My take:
=IFERROR(VLOOKUP(C2'https://omegaingredients-my.sharepoint.com/:x:/g/personal/link/edited/for/privacy'!$A$1:$S$500,9,0),"not found")
My intention is for the formula to look at column C on the local spreadsheet (i.e it says 'Apple' on C2)
Then go to the OneDrive spreadsheet and find 'Apple' in column C (let's say it's C4 in this example).
Then I need the spreadsheet to look at column I4 on the OneDrive sheet which is the price for the Apple.
The formula then needs to pull this information over to the local spreadsheet in I2.
I can't attach the spreadsheet as it's for work purposes and includes intellectual property so hoping my explanation above works!
Thanks!
Bookmarks