Supported Excel Functions

VLOOKUP function

Syntax

VLOOKUP(lookup_value, table_array_name, col_index_num, range_lookup)

lookup_value    Required.
The value you want to look up.

table_array_name    Required.
The name of a TableArray object in which the VLOOKUP will search for the lookup_value and the return value. The scope of the search is limited by the left-most column of a TableArray object. The TableArray objects are placed in a HashMap and retrieved by their names during the formula evaluation.

col_index_num    Required.
The column number (starting with 1 for the left-most column of a TableArray object).

range_lookup    Required.
A value that specifies whether you want VLOOKUP to find an approximate or an exact match:

• Approximate match: 1
  uses the fact that the elements of the left-most column of a TableArray object are internally sorted either numerically or alphabetically (whichever is applicable) and searches for the TableArray element closest to the lookup_value.
• Exact match: 0
  searches for the exact value in the left-most column of a TableArray object.

Looks up a value in the left-most column of a TableArray object and then returns a value in the same column from a column you specify in a TableArray object.

If range_lookup is 0 and lookup_value is a text string, you can use the wildcard characters: the question mark (?) and asterisk (*) in the lookup_value argument.
A question mark matches any single character; an asterisk matches any sequence of characters. If you want to find an actual question mark or asterisk, type a tilde (~) before the character.

This is the Adaptive Calculation Engine implementation of the Excel VLOOKUP function.