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

Break Down the Problem

To identify which argument in XLOOKUP determines the search order for values returned from the lookup_array, we need to examine the XLOOKUP function's arguments.

Relevant Concepts

The XLOOKUP function has several arguments:

• lookup_value: the value to search for.
• lookup_array: the array to search in.
• return_array: the array from which to return values.
• if_not_found: the value to return if a match is not found.
• match_mode: the mode for matching the lookup value.
• search_mode: the order in which to search the lookup array.

Analysis and Detail

1. match_mode: This defines how the function matches the lookup value to the values in the lookup_array but does not define the search order.
2. search_mode: This argument specifies the search order within the lookup_array. You can specify to search from first to last, last to first, or a binary search.
3. not_found: This argument does not relate to the search order but deals with what to return if no match is found.
4. return_array: This pertains to where the values are taken from after the match is found.

Verify and Summarize

Based on the analysis, the argument that determines the search order in the XLOOKUP function is search_mode.

Final Answer

B: search_mode is the argument that determines the search order for values returned from the lookup_array in XLOOKUP.