vlookup- is a must that lookup value should be the leftmost colum?

[Guest]

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,

 

[Guest]

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

 

[Guest]

many thanks, max. I seldom use index and match, maybe I need more practice.

 

[Guest]

You're welcome. Once you get the hang of it, think you'd find index/match as
easy to apply and more versatile <g>.