Function VLOOKUP Excel for web

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)


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


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.