Allow VLOOKUP across Online workbooks
In Excel client, it is possible to define a VLOOKUP across two workbooks. Not just sheets within a Workbook, but across two different files. Excel will retrieve and keep the filename and path.
At one time this allowed me to create a complex (ever changing) network of various different but related data listings, without having to copy list 1 to workbook 2 for VLOOKUP validation. The files were stored on a fileserver that everybody had access to using the same Drive letter. Yes, this is old school.
Now in the Online world, I want people to work on different workbooks, but they should all make use of one or other master code list. So that the different data listings reference the same things by the same name. For example, where lists of systems, applications, people, locations, departments, etc. all need to reference the same list of processes.
Not being able to link one online file to another so that I can use that link in a VLOOKUP, means I have to copy the referenced list to many other workbooks and then keep the synchronisation up to date manually.
If it were me, I would want to be able to define a hyperlink to a sheet in an online workbook, then give that hyperlink a name. I would then want to be able to use that hyperlink name in VLOOKUP and other such functions. The hyperlink should survive Excel client editing.
Now wouldn't that be something?
santosh kumar commented
vlookup compare all sheets
please add this function
Akshay Vidwans commented
Please add this feature. It doesnt work for workbooks stored on desktop on one drive either.
I used Vlookup all the time on my desktop excel. Not having the feature in One Drive for Excel is not a good thing. The function keys need to ALL work in Excel online.
Please add this feature
Yes please add this function to Excel online
MS can ref Google for how they can successfully accomplish this as you can do this in Google Drive already. Badly need this functionality within onedrive excel sheets for collaboration.
Related to this topic is the ability to use vlookup across workbooks that are not using the same instance of Excel. i.e. If I open the two workbooks using separate instances of Excel - Excel doesn't "see" the table I have found in the other workbook. However, if I open the two workbooks using a single instance of Excel, things work perfectly.
Being able to open the two workbooks in different instances would make trouble shooting and side by side comparisons easier than doing a split screen. (Especially when more than the 2 workbooks that are needed for comparison are open)