XMATCH only supports one-dimensional arrays or ranges, either vertical and horizontal. Finally, search_mode controls the search direction - whether XMATCH should start at the beginning of the array, at the end of the array, or if XMATCH should perform a binary search. The match_mode argument controls what kind of match is performed (exact, next smallest, next largest, or wildcard), see match_mode below for details. Lookup_value is the value to look for, and lookup_array is the range or array to search. The XMATCH function takes four arguments: lookup_value, lookup_array, match_mode, and search_mode. Finally, XMATCH can perform binary searches, which are specifically optimized for speed. Like the XLOOKUP function, XMATCH can search data starting from the first value or the last value (i.e. XMATCH supports both approximate and exact matches, and wildcards (* ?) for partial matches. XMATCH can perform lookups in vertical or horizontal ranges, and is meant to be a more flexible and powerful successor to the MATCH function. The Excel XMATCH function performs a lookup and returns a position.
0 kommentar(er)
