G Guest Jan 22, 2005 #1 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?
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?
D Domenic Jan 22, 2005 #2 You can use a combination of INDEX and MATCH functions. For example... =INDEX(Array,MATCH(LookupValue,LookupArray,MatchType)) Hope this helps!
You can use a combination of INDEX and MATCH functions. For example... =INDEX(Array,MATCH(LookupValue,LookupArray,MatchType)) Hope this helps!
A Aladin Akyurek Jan 22, 2005 #3 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? Click to expand... 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 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? Click to expand... 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 Guest Jan 22, 2005 #4 Thank YOu. 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? Click to expand... 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)) Click to expand...
Thank YOu. 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? Click to expand... 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)) Click to expand...
