Home

BUSCARV in a left had column

%3CLINGO-SUB%20id%3D%22lingo-sub-758560%22%20slang%3D%22en-US%22%3EBUSCARV%20in%20a%20left%20had%20column%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-758560%22%20slang%3D%22en-US%22%3E%3CP%3EHi%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20wonder%20if%20there%20exists%20a%20way%20to%20use%20the%20function%20%3DBUSCARV%20where%20the%20column%20of%20values%20is%20at%20the%20left%20of%20the%20column%20to%20look%20in.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIt%20would%20be%20like%20use%20this%20pattern%26nbsp%3B%3DBUSCARV(W5%3Bvalores!%24D%241%3A%24E%2460%3B-1%3BFALSO)%20where%20'-1'%20would%20represent%20one%20step%20on%20the%20left%20side.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-758560%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-758733%22%20slang%3D%22en-US%22%3ERe%3A%20BUSCARV%20in%20a%20left%20had%20column%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-758733%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F377525%22%20target%3D%22_blank%22%3E%40LUIS_MENENDEZ%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EHi%3C%2FP%3E%0A%3CP%3EI%20don't%20know%20the%20names%20of%20the%20Functions%20in%20your%20language%2C%20other%20than%20BUSCARV%20is%20VLOOKUP%20in%20English.%3C%2FP%3E%0A%3CP%3EVlookup%20can%20only%20return%20values%20to%20the%20right%20of%20the%20value%20being%20looked%20up%2C%20except%20for%20one%20small%20trick%20using%20the%20CHOOSE%20function%20as%20well%20(which%20in%20my%20opinion%20is%20not%20worth%20using).%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EInstead%20of%20Vlookup%2C%20I%20always%20use%20a%20combination%20of%20INDEX%20and%20MATCH.%20which%20is%20much%20more%20versatile%20and%20allows%20you%20to%20look%20in%20either%20direction.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EIf%20you%20look%20at%20the%20attached%20file%20I%20have%20shown%20examples%20of%20How%20Index%20works%20and%20how%20Match%20works%20and%20how%20to%20use%20them%20in%20combination.%3C%2FP%3E%0A%3CP%3EOnce%20you%20et%20used%20to%20them%2C%20you%20will%20never%20go%20back%20to%20Vlookup.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
LUIS_MENENDEZ
Occasional Visitor

Hi,

 

I wonder if there exists a way to use the function =BUSCARV where the column of values is at the left of the column to look in.

 

It would be like use this pattern =BUSCARV(W5;valores!$D$1:$E$60;-1;FALSO) where '-1' would represent one step on the left side.

 

Thanks

1 Reply

@LUIS_MENENDEZ 

Hi

I don't know the names of the Functions in your language, other than BUSCARV is VLOOKUP in English.

Vlookup can only return values to the right of the value being looked up, except for one small trick using the CHOOSE function as well (which in my opinion is not worth using).

 

Instead of Vlookup, I always use a combination of INDEX and MATCH. which is much more versatile and allows you to look in either direction.

 

If you look at the attached file I have shown examples of How Index works and how Match works and how to use them in combination.

Once you et used to them, you will never go back to Vlookup.

 

Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
46 Replies
Extentions Synchronization
Deleted in Discussions on
3 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
29 Replies
flashing a white screen while open new tab
Deleted in Discussions on
14 Replies
Security Community Webinars
Valon_Kolica in Security, Privacy & Compliance on
13 Replies