The XLOOKUP function is designed to search through a range or array and return a value that corresponds to the first match it finds. Unlike its predecessors — ...