Friday, February 28, 2014
MS Excel: Lookup instead of Vlookup or Hlookup
The limitation of vlookup is that you can only lookup in the first column of array and bring back results from it or any column right of it.
Similar limitation in Hlookup where you can only lookup in first row of array and bring back result from it or any row below it.
To get over with this limitation, use lookup instead of vlookup and Hlookup:
=lookup(Lookup Value, Lookup Vector, Result Vector)
See the examples below:
Use of Lookup for Vlookup
Use of lookup for Hlookup