Forum Discussion
LookUpv with other books
Hi Mr mathetes
Thank you for your soon reply, it was my mistake, it is VLOOKUP, and as I told you it's to use this function with other books that I have in my sharepoint. For example, I have "Book1" and "Book2" and i would like to use VLOOKUP from "BOOK1" to "BOOK2".
Is it possible? because I'm using Office 365.
I im goint to wainting for your comments.
Best regards.
It is possible, yes. I made several other observations about the syntax in the function/formula you originally posted, so I'm curious whether you made any other changes.
I too have a Microsoft 365 subscription (their new name for what used to be Office 365)...and just made a VLOOKUP work from one sheet to another. In your original posting you mentioned also being in Sharepoint--which I don't use. I suppose it's possible that there are unique limitations there of which I'm not aware. More likely there's another cause.
You also just said "It doesn't work" which is open to multiple interpretations. Do you get one of Excel's many error messages? Or is it just blank, not accepted as a formula. Or are you getting a result but not the one expected. "Doesn't work" doesn't work as a complete description.
Can you upload a sample of your two sheets?
- DiegoFFPRMay 27, 2020Copper Contributor
Hi Mr. mathetes
Thank you for your soon reply, I'm going to share pics of my data.
Hope this help you.
I'm going to waiting for your comments.
Best regards.
- mathetesMay 27, 2020Gold Contributor
Unfortunately images alone are of only limited value. I can tell you, though, that VLOOKUP isn't going to work well because there are multiple identical instances of the emails. VLOOKUP is intended to work with tables where the value being sought (as the key to the other columns in that row) is a unique value, definitely not one that is repeated many times. In other words, VLOOKUP for mauricio.casanova@prosegur.com has more than one possible result, depending on which row you get to; it will (or should) return the first value it finds...... but that's just not good design.
So you really need to do a better job describing what you're trying to accomplish. And unless you can upload the actual sheets, I am afraid I can't be of much help. I'm sorry.