How To Use Basic Excel XLOOKUP Function


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.


XLOOKUP helps to find the value in a range


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
scroll to top