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.