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, |
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, |
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, |
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.:) |
All times are GMT +1. The time now is 04:26 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com