If a valid match is not found, and is missing, #N/A is returned.Ġ - Exact match. Where a valid match is not found, return the text you supply.
*If omitted, XLOOKUP returns blank cells it finds in lookup_array. =XLOOKUP(lookup_value, lookup_array, return_array, , , ) If no match exists, then XLOOKUP can return the closest (approximate) match. The XLOOKUP function searches a range or an array, and then returns the item corresponding to the first match it finds.
