Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Vlookup query
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? |
#2
|
|||
|
|||
You can use a combination of INDEX and MATCH functions. For example...
=INDEX(Array,MATCH(LookupValue,LookupArray,MatchTy pe)) Hope this helps! In article , gb_S49 wrote: 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? |
#3
|
|||
|
|||
gb_S49 wrote:
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)) |
#4
|
|||
|
|||
Thank YOu.
Have a nice weekend "Aladin Akyurek" wrote: gb_S49 wrote: 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)) |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Query of External Data | Excel Discussion (Misc queries) | |||
Microsoft Query Help | Excel Worksheet Functions | |||
How to use a Access Query that as a parameter into Excel database query | Excel Discussion (Misc queries) | |||
Editing MS Query | Excel Worksheet Functions | |||
VLOOKUP not working | Excel Worksheet Functions |