Which statement about XLOOKUP is true?

Which statement about XLOOKUP is true?

• A. XLOOKUP offers flexible matching options including exact and approximate.
• B. XLOOKUP can only search the first column.
• C. XLOOKUP returns values only to the left of the lookup.
• D. XLOOKUP is identical to VLOOKUP in capability.

Answer: (A)

XLOOKUP's power lies in its flexible matching options, including exact and approximate comparisons. You control this with the match_mode parameter: 0 for an exact match, -1 for exact or next smaller, 1 for exact or next larger, and -2 for wildcard matching. This lets you either require an exact value or return the closest match when an exact one isn't present, without needing to sort data for approximate lookups. Another strength is that XLOOKUP can search in any part of the lookup array and return a value from any part of the return array, so you're not limited to the leftmost column. This is why the statement about flexible matching is true and why the other statements don’t fit: it doesn't force you to search the first column, it doesn't restrict returns to the left, and it's not identical to VLOOKUP, since it offers more options and a different, simpler syntax.

XLOOKUP's power lies in its flexible matching options, including exact and approximate comparisons. You control this with the match_mode parameter: 0 for an exact match, -1 for exact or next smaller, 1 for exact or next larger, and -2 for wildcard matching. This lets you either require an exact value or return the closest match when an exact one isn't present, without needing to sort data for approximate lookups. Another strength is that XLOOKUP can search in any part of the lookup array and return a value from any part of the return array, so you're not limited to the leftmost column. This is why the statement about flexible matching is true and why the other statements don’t fit: it doesn't force you to search the first column, it doesn't restrict returns to the left, and it's not identical to VLOOKUP, since it offers more options and a different, simpler syntax.