Vlookup query

[gb_S49]

when using vlook, it always goes from the Left column to Right column. Is it
possible to use vlook to the left.
did that make sense?

 

[Domenic]

You can use a combination of INDEX and MATCH functions. For example...

=INDEX(Array,MATCH(LookupValue,LookupArray,MatchType))

Hope this helps!

 

[Aladin Akyurek]

when using vlook, it always goes from the Left column to Right column. Is it
possible to use vlook to the left.
No.

did that make sense?

Yes. You need to switch to an INDEX/MATCH or LOOKUP formula...

If you can set the match-type (range_lookup in MS parlance) to 1 (or
TRUE)...

1]

=LOOKUP(X2,$B$2:$B$10,$A$2:$A$10)

2]

=INDEX($A$2:$A$10,MATCH(X2,$B$2:$B$10,1))

If you have to set the match-type to 0 (or FALSE)...

=INDEX($A$2:$A$10,MATCH(X2,$B$2:$B$10,0))

 

[gb_S49]

Thank YOu.
Have a nice weekend

when using vlook, it always goes from the Left column to Right column. Is it
possible to use vlook to the left.
No.

did that make sense?

Yes. You need to switch to an INDEX/MATCH or LOOKUP formula...

If you can set the match-type (range_lookup in MS parlance) to 1 (or
TRUE)...

1]

=LOOKUP(X2,$B$2:$B$10,$A$2:$A$10)

2]

=INDEX($A$2:$A$10,MATCH(X2,$B$2:$B$10,1))

If you have to set the match-type to 0 (or FALSE)...

=INDEX($A$2:$A$10,MATCH(X2,$B$2:$B$10,0))