Summary
XLOOKUP is new function in Excel which is replacement of functions like VLOOKUP, HLOOKUP, and LOOKUP. XLOOKUP will helps to support exact match, approximate match, partial match, and lookup in Vertical or Horizontal.
Purpose
XLOOKUP helps to find the value in a range
Syntax
XLOOKUP (lookup_value, lookup_array, return_array, [if_not_found], [match_model], [search_mode])
Example Explanation
By default XLOOKUP will give Exact match result. In the above mentioned example we are looking for Sales of Product T-Shirt based on the Exact match mode. Formula in cell H6 is:
Arguments in Example
G6 – The lookup value
C6:C14 – The array or range to look
D6:D14 – The array or range to return
