| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
vlookup- is a must that lookup value should be the leftmost colum?
Since the table which i want to search are often not ranged as the lookup
value located in the leftmost column, should I always need to adjust the column sequence of the table so as to use "Vlookup" function. It's really a bother. Can anybody kindly help? Thanks, |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
vlookup- is a must that lookup value should be the leftmost colum?
INDEX/MATCH would fit the bill .. You can match on any column, and return any
other column via the INDEX part of it, eg to exact match a lookup value in A1 against col AZ & return from col K would look like this: =INDEX(K:K,MATCH(A1,AZ:AZ,0)) Try Debra Dalgleish's nice coverage on INDEX/MATCH at her: http://www.contextures.com/xlFunctions03.html INDEX/MATCH There's also some sample workbooks available for d/l & study -- Max Singapore http://savefile.com/projects/236895 xdemechanik --- "hettie" wrote: Since the table which i want to search are often not ranged as the lookup value located in the leftmost column, should I always need to adjust the column sequence of the table so as to use "Vlookup" function. It's really a bother. Can anybody kindly help? Thanks, |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
vlookup- is a must that lookup value should be the leftmost co
many thanks, max. I seldom use index and match, maybe I need more practice.:)
"Max" wrote: INDEX/MATCH would fit the bill .. You can match on any column, and return any other column via the INDEX part of it, eg to exact match a lookup value in A1 against col AZ & return from col K would look like this: =INDEX(K:K,MATCH(A1,AZ:AZ,0)) Try Debra Dalgleish's nice coverage on INDEX/MATCH at her: http://www.contextures.com/xlFunctions03.html INDEX/MATCH There's also some sample workbooks available for d/l & study -- Max Singapore http://savefile.com/projects/236895 xdemechanik --- "hettie" wrote: Since the table which i want to search are often not ranged as the lookup value located in the leftmost column, should I always need to adjust the column sequence of the table so as to use "Vlookup" function. It's really a bother. Can anybody kindly help? Thanks, |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
vlookup- is a must that lookup value should be the leftmost co
You're welcome. Once you get the hang of it, think you'd find index/match as
easy to apply and more versatile <g. -- Max Singapore http://savefile.com/projects/236895 xdemechanik --- "hettie" wrote: many thanks, max. I seldom use index and match, maybe I need more practice.:) |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Double lookup without using vlookup? | Excel Worksheet Functions | |||
| IF, VLOOKUP & LOOKUP TABLE ON OTHER SHEET | Excel Discussion (Misc queries) | |||
| vlookup using two lookup values? | Excel Worksheet Functions | |||
| Lookup without VLOOKUP? | New Users to Excel | |||
| VLOOKUP - dealing with lookup_value differences | Excel Worksheet Functions | |||
Linear Mode
