An optional argument in the XLOOKUP function that specifies a custom value to return when no match is found.
Thử với AIThe if_not_found argument allows users to define a fallback result, such as text or a zero, instead of the default #N/A error. This improves spreadsheet readability by handling missing data gracefully without requiring additional error-trapping functions like IFERROR.
=XLOOKUP(lookup_value, lookup_array, return_array, [if_not_found])=XLOOKUP("Apple", A2:A10, B2:B10, "Not Found") will return "Not Found" if "Apple" is missing from the range.
If omitted, XLOOKUP will return the standard #N/A error when no match is found.