19 Mar 2026 ... How to Use XLOOKUP for Approximate Match, Wildcards, and Last Match# ; Next smaller match, =XLOOKUP(B2,$M$2:$M$8,$N$2:$N$8,"",-1), Rate cards, ...