What happens if XLOOKUP can't find a matching result for the lookup value?AIt returns an #N/A errorBIt returns the closest approximate matchCIt displays a warning messageDIt automatically inserts the missing value

What happens if XLOOKUP can't find a matching result for the lookup value?AIt returns an #N/A errorBIt returns the closest approximate matchCIt displays a warning messageDIt automatically inserts the missing value

Which of the following statements about XLOOKUP is true?AIt requires the lookup and return arrays to be sortedBIt only works with numeric dataCIt doesn't support approximate matchesDIt can't handle multi-sheet workbooks

Which TWO of the following statements are true for XLOOKUP()?1 pointThe lookup array and return array have to be the same size.The lookup array and return array have to be next to each other.The lookup array and return array have to be on the same worksheet.You can set up a default value or string to return if the searched-for value is not found.

Which argument in XLOOKUP determines the search order for values returned from the lookup_array?Amatch_modeBsearch_modeCnot_foundDreturn_array

How does XLOOKUP handle multiple matches in the search array?AReturns the first match foundBReturns an array of all matching valuesCReturns the last match foundDIt depends on the order of values in the search array