The vector syntax for LOOKUP looks for a matching value in a range of
cells (vertical or horizontal) and returns the value in the matching
vector position of the second supplied range. It is similar to VLOOKUP and HLOOKUP; however, it is limited to a single row or column to hold results.
VLOOKUP looks for a matching value in the first column of a range of
cells and returns the value from the same row in the column of the range
you specify. The range can have multiple columns. LOOKUP would have
only one column to choose from.
To discrbe the difference, I would say LOOKUP has a single column or
row range to hold the lookup values, and a single column or row range to
hold the return values. The return range does not need to be adjacent
to the lookup range, but can be. VLOOKUP can have multiple columns, the
first being the lookup column. The other columns hold the result values
and are choosen by the column parameter. The VLOOKUP fucntion uses a
single multi-cell range.
What's the difference between LOOKUP function and VLOOKUP in Excel?
No comments:
Post a Comment