VLOOKUP
Searches for a value in the first column of a table array and returns a value in the same row from a specified column.
| Category | Lookup |
| Syntax | VLOOKUP(lookup_value, table_array, col_index, [range_lookup]) |
Parameters
| Parameter | Required | Description |
|---|---|---|
lookup_value | Required | The value to search for in the first column of the table array. |
table_array | Required | The range of cells that contains the data (e.g., A1:C10 or $Table[A1:C10]). |
col_index | Required | The column number in the table_array from which the matching value should be returned. |
range_lookup | Optional | [Optional] TRUE (default) for approximate match (data must be sorted). FALSE for exact match. |
Example
// Look up beam depth from a table in Sheet2
VLOOKUP("W14x22", Sheet2!A1:D50, 3, FALSE)
Auto-generated from the EngCanvas function registry.