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,