Excel XMATCH Function | XMATCH Function | Excel 2021
Excel XMATCH Function Summary The Excel XMATCH function makes a look-up and sends back the location in vertical or horizontal arrays. It is a more strong and stretchy replacement to the MATCH function in excel. XMATCH supports estimated and exact matching, inverse search, and wildcards (* ?) for limited matches. Purpose Get the location of an element in a list or table Return value Numeric spot in look-up array Syntax =XMATCH (lookup_value, lookup_array, [match_mode], [search_mode]) Arguments lookup_value - The lookup value. The main data to start search. lookup_array - The range to search the data item. match_mode - [optional] 0 = exact match (by default), -1 = exact match or the next smallest, 1 = exact match or the next larger, 2 = wildcard match support (If any). search_mode - [optional] 1 = search from the first (default), -1 = search from the last, 2 = ascending binary ...