medium10 pts · first answer countsexcel-modelling

XLOOKUP default behaviour

You write =XLOOKUP(A2, Codes, Prices) to fetch a price for a product code. If you do not pass a match_mode, how does XLOOKUP match?

A.Exact match, and it returns #N/A if the code is not foundB.Approximate match on the next smaller valueC.Wildcard match using * and ?D.It requires the Codes column to be sorted ascending

Discussion 0

Join free to post in the discussion.

XLOOKUP default behaviour

Discussion 0

Related questions