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
No comments:
Post a Comment