VLOOKUP between two web based Excel files (SharePoint)
I’d like to create a lookup sheet for a messy spreadsheet we currently use. Both documents will be web-based Excel files and I’d like to use Vlookup to create a sheet to easily pull certain information from this messy spreadsheet with multiple tabs we are forced to use. Is this possible?
Something like this below
=VLOOKUP(b3,'[https://sharepoint[filename.xlxs]COUNTIF(INDIRECT("'"&SheetList&"'!$B1:$N700"),3,false))
Thanks for your help.
Bottom line appears to be that it's not easy. However, see here, if you haven't found this one already:
https://social.msdn.microsoft.com/Fo...forum=exceldev
Glenn
None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU.
Temporary addition of accented to illustrate ongoing problem to the TT: L? fh?ile P?draig sona dhaoibh
I saw that, but it was 9 years ago and Excel wasn't online like it is now. I hope there have been major improvements.
Has anything from the site https://social.msdn.microsoft.com/Forums ever been helpful and not a bunch of convoluted BS? That's why I prefer Excel forums.
Never found much of use there myself.
Another random thought. Since INDIRECT only works on open files, can't you just shift from one file to the other??
I didn't realize INDIRECT only works on open files. So that option won't work for me.
Any thoughts on how to pull information from a messy spreadsheet with numerous worksheets?
The worksheets have blank rows so filtering never works and I just want to put in a sales order number and pull information relevant to my department.
Thanks again!
How many is numerous? I do have a way of doing this, but it's a bit of a pain to set up.
I would also need to see a suitably anonymised version of both target and destination sheets.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks