V Look Up to the Left Side

[shaftdx]

Good Morning all.

I am still learning the intricacies of V Look up and am very excited about the possibilities i can utilize it for. Is there a away I can have it pull info from the left of the column I need? or is it only to the right? I am pulling things that have to be in a certain order in the main spreadsheet so I can format it to update to a CBV Calendar.

 

[steve the fish]

No you cant with vlookup. You will need xlookup or if you dont have it then index/match combo.

 

[Sufiyan97]

You can use INDEX and MATCH to lookup left side

How to use INDEX and MATCH

INDEX and MATCH is the most popular tool in Excel for performing more advanced lookups. This is because INDEX and MATCH are incredibly flexible – you can do horizontal and vertical lookups, 2-way lookups, left lookups, case-sensitive lookups, and even lookups based on multiple criteria. If you...

exceljet.net

 

[shaftdx]

Thank you both!

 

[Peter_SSs]

@shaftdx

I suggest that you update your Account details (or click your user name at the top right of the forum) so helpers always know what Excel version(s) & platform(s) you are using as the best solution often varies by version. (Don’t forget to scroll down & ‘Save’)

 

[shaftdx]

@shaftdx

I suggest that you update your Account details (or click your user name at the top right of the forum) so helpers always know what Excel version(s) & platform(s) you are using as the best solution often varies by version. (Don’t forget to scroll down & ‘Save’)

Ok done. I left it blank before only because I have a work computer and a home one with 2 different versions of Excel I will just have to specify from now on when I am at home and that version when I have a problem there. Thank you for the help!

 

[Peter_SSs]

Thanks for updating your profile.

I have a work computer and a home one with 2 different versions of Excel

You can mark multiple versions in your Account details. However, you are right in that you may need to specify which version you are wanting help with each time.

 

[daregu]

Good Morning all.

I am still learning the intricacies of V Look up and am very excited about the possibilities i can utilize it for. Is there a away I can have it pull info from the left of the column I need? or is it only to the right? I am pulling things that have to be in a certain order in the main spreadsheet so I can format it to update to a CBV Calendar.

If you have updated to office 365 which I highly suggest you do, then I'd say xlookup would be your best option.

 

[alansidman]

Here is a vlookup to the left formula.

LeftVLOOKUP.xls
	A	B	C	D	E	F
1	5		a		b	10
2	10		b
3	15		c
4	20		d
5	25		e
6	30		f
7	35		g
Sheet4

Cell Formulas
Range	Formula
F1	F1	=VLOOKUP(E1, CHOOSE({1,2}, $C$1:$C$7, $A$1:$A$7), 2, 0)

=vlookup(Value to Lookup,Choose({1,2},Range To Find Lookup Value, Range to Find Answer), Columns Offset to left, 0)