#partial-match

XLOOKUP Wildcard and Partial Match in Excel and Google Sheets

XLOOKUP treats * as a character until match mode is 2. SKU-10* missed every row here until I set that, and the first hit was SKU-101.