G
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?
possible to use vlook to the left.
did that make sense?
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
D
Domenic
You can use a combination of INDEX and MATCH functions. For example...
=INDEX(Array,MATCH(LookupValue,LookupArray,MatchType))
Hope this helps!
=INDEX(Array,MATCH(LookupValue,LookupArray,MatchType))
Hope this helps!
A
Aladin Akyurek
gb_S49 said: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))
G
gb_S49
Thank YOu.
Have a nice weekend
Have a nice weekend
Aladin Akyurek said:gb_S49 said: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))