Forum Discussion

DiegoFFPR's avatar
DiegoFFPR
Copper Contributor
May 26, 2020

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 f...
excel
Formulas and Functions
office 365
mathetes's avatar
mathetes
Gold Contributor
May 28, 2020

DiegoFFPR 

 

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.

Resources