Forum Discussion
LookUpv with other books
I can't tell for sure, but your syntax looks strange. And I've never seen LOOKUPV as a function. Is it in Sharepoint?
In Excel it would be VLOOKUP
You'd begin with an = rather than a + (that may have been a typo, I realize)
And the separators between arguments would be a comma rather than semicolon.
If those suggestions don't resolve your issue, perhaps you could upload sample sheets.
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?
