SOLVED

Function VLOOKUP Excel for web

%3CLINGO-SUB%20id%3D%22lingo-sub-2170304%22%20slang%3D%22en-US%22%3EFunction%20VLOOKUP%20Excel%20for%20web%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2170304%22%20slang%3D%22en-US%22%3E%3CP%3EHow%20can%20I%20use%20the%20function%20VLOOKUP%20with%20two%20Excel%20files%20in%20the%20Excel%20online%20(I%20mean%20with%20the%20files%20in%20a%20OneDrive%20Cloud)%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2170304%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Occasional Visitor

How can I use the function VLOOKUP with two Excel files in the Excel online (I mean with the files in a OneDrive Cloud)?

1 Reply
best response confirmed by dalves (Occasional Visitor)
Solution

@dalves 

If you mean Excel Online - so far it doesn't support references on another workbooks, thus that doesn't work.

 

If you mean Excel Desktop working with files kept on OneDrive - same way as with files on local drive or on network share, the only file path looks bit different, like

=XLOOKUP(A1,
'https://n-my.sharepoint.com/personal/acc/Documents/[Book1.xlsx]Sheet1'!$A$1:$A$11,
'https://n-my.sharepoint.com/personal/acc/Documents/[Book1.xlsx]Sheet1'!$B$1:$B$11)

The easiest way in such case is to open both files, create references by selecting ranges by mouse. After the file is closed path will be added to reference automatically.