Excel: XLOOK UP (Part 1)

XLOOKUP 

XLOOKUP function is a modern and flexible replacement for older functions like VLOOKUP, HLOOKUP, REVERSE VLOOKUP, LOOKUP, INDEX, MATCH, and IFFERROR. XLOOKUP is a modern replacement for the VLOOKUP function. It is a flexible and versatile function that can be used in a wide variety of situations. It supports approximate and exact matching, wildcards (* ?) for partial matches, and lookups in vertical or horizontal ranges. XLOOKUP can find values in vertical or horizontal ranges, can perform approximate and exact matches, and supports wildcards (* ?) for partial matches. In addition, XLOOKUP can search data starting from the first value or the last value (see match type and search mode details below).  Compared to older functions like VLOOKUP, HLOOKUP, and LOOKUP, XLOOKUP offers several key advantages. If XLOOKUP can't find a match, it returns the #N/A error, like other match functions in Excel. Unlike the other match functions, XLOOKUP supports an optional argument called not_found that can be used to override the #N/A error when it would otherwise appear. Typical values for not_found might be "Not found", "No match", "No result", etc. When providing a value for not_found, enclose the text in double quotes (""). 

Arguments of XLOOKUP Function:

lookup - The lookup value.

lookup_array - The array or range to search.

return_array - The array or range to return.

not_found - [optional] Value to return if no match found. (Like If error function.)

match_mode - [optional] 0 = exact match ( which is default), 1 = exact match or nearest larger number, -1 = exact match or nearest smaller number, 2 = its enable wildcard match.

search_mode - [optional] 1 = search from top to bottom of left to right (default), -1 = search from bottom to top or right to left.