Feb 26 2021
How can I use the function VLOOKUP with two Excel files in the Excel online (I mean with the files in a OneDrive Cloud)?
View best response
Feb 27 2021
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.