WD.VLOOKUP
Description
Finds a value in the leftmost column of the specified array, and returns the value for the corresponding cell in the same row in a different column. This function is the same as VLOOKUP but WD.VLOOKUP creates an index (b-tree) for the specified ranges/arrays, and it ignores the
range_lookup
argument. This function provides better performance for repeated use on the same range/array. Null and error values are ignored. Syntax
WD.VLOOKUP(
lookup_value
, table_array
, col_index_num
, [ range_lookup
]) - lookup_value: The value to find in the first column.
- table_array: The array or table to search.
- col_index_num: The column to return the corresponding value from.
- range_lookup: Not used.
Example
The example is based on this workbook:
A | B | C | D | |
|---|---|---|---|---|
1 | Salesperson | Customer | Product | Revenue |
2 | Dixon | O'Reilly, Auer, & Lind | Qosolex | $8,232,000.00 |
3 | Dixon | Runolfsson and Steuber | Saoplus | $4,853,000.00 |
4 | Kelly | Kuphal Group | Qosolex | $2,358,000.00 |
5 | Kelly | Ernser Inc | Voltflarn | $2,064,000.00 |
6 | Payne | Williamson Group | Singlflix | $6,974,000.00 |
7 | Payne | Ratke-Sanford | Qosolex | $8,433,000.00 |
8 | Payne | Leuschke and Sons | Qosolex | $8,181,000.00 |
9 | Wu | Dach-Halvorson | Singlflix | $2,361,000.00 |
10 | Wu | Wisoky LLC | Bextain | $5,752,000.00 |
11 | Wu | Stiedemann Grp | Saoplus | $3,987,000.00 |
The result of
=WD.VLOOKUP(A6,$A$2:$D$11,4)
is $6,974,000.00
. Related Functions
ARRAYAREA
GROUPBY
MATCHEXACT
WD.MVLOOKUP