How to Use XLOOKUP Function in Excel? - ExcelDemy How to Use XLOOKUP Function in Excel? Searches a range or an array for a match and returns the corresponding item from a second range or array It’s the specified value that needs to be searched for in the data table The lookup_array is a range of cells or an array where the lookup_value will be searched for