Forum Discussion
LookUpv with other books
Hi everyone,
I've a question, I created a sharepoint group and inside that group i created two excel documents, my question is, how can i made a lookupv with "book1" to "book2"I tried with this formula.
+LOOKUPV(W2;[Base Comecial.xlsx]Data Comercial!$F:$G;2;0), but it doesn't work.
I'll waiting for your comments.
Best Regards.
PSDT: All the information is in Office 365.
6 Replies
You posted the formula as +LOOKUPV(W2;[Base Comecial.xlsx]Data Comercial!$F:$G;2;0)
And in my very first answer, I commented on your use of semicolons (";") in place of commas (",") as incorrect, along with the need to begin the function with an equals sign rather than a plus sign. You've never responded to those observations.
So in addition to telling you more recently that the table in which you're trying to perform a VLOOKUP--because it has multiple identical fields in the "W" column, so the results will be dicey at best....you're really not writing the formula correctly.
=VLOOKUP(W2,[Base Comercial.xlsx]Data Comercial!$F:$G,2,0) would be the correct way to write that formula. However, as noted, it is going against an improperly organized table.
Could you please tell us what the results ARE, rather than just saying the "results are not what I want." That's saying what they're NOT; what DOES happen? Is it an error message? Is it a result but a different result than you think correct?
And again, if you can upload the actual spreadsheets behind these images, that would go a long way toward having others help you.
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?
