XLOOKUP Function Explained
The XLOOKUP Function in Microsoft Excel is used to look up and retrieve data from a table or range by row. It is an improved version of the VLOOKUP Function, and it can search for a value both vertically and horizontally. It can also return multiple values, and it has the ability to search for approximate matches.
XLOOKUP Function Syntax
XLOOKUP(lookup_value, lookup_vector, result_vector, [if_not_found], [match_mode], [search_mode])
- lookup_value: The value to search for in the lookup_vector.
- lookup_vector: The range of cells to search for the lookup_value.
- result_vector: The range of cells to return a value from if the lookup_value is found.
- if_not_found: (Optional) The value to return if the lookup_value is not found in the lookup_vector.
- match_mode: (Optional) Specifies whether to find an exact or approximate match for the lookup_value. Possible values are 1 (exact match) or -1 (approximate match).
- search_mode: (Optional) Specifies whether to search for the lookup_value in the first column or the first row of the lookup_vector. Possible values are 1 (search first column) or -1 (search first row).