XLOOKUP
Searches a range or array for a match and returns the corresponding item from a second range or array.
| Category | Lookup |
| Syntax | XLOOKUP(lookup_value, lookup_array, return_array, [if_not_found], [match_mode], [search_mode]) |
Parameters
| Parameter | Required | Description |
|---|---|---|
lookup_value | Required | The value to search for. |
lookup_array | Required | The array or range to search. |
return_array | Required | The array or range to return a result from. |
if_not_found | Optional | Value to return if no match is found. |
match_mode | Optional | 0 (exact), -1 (exact or next smaller), 1 (exact or next larger), 2 (wildcard). Defaults to 0. |
search_mode | Optional | 1 (first-to-last), -1 (last-to-first), 2 (binary asc), -2 (binary desc). Defaults to 1. |
Example
XLOOKUP(value, range, col)
Auto-generated from the EngCanvas function registry.