Excel Comparison
XMATCH vs MATCH in Excel and Google Sheets
MATCH without 0 is approximate: SKU-110 returned position 5, not 3. XMATCH defaults to exact. A text third argument was #VALUE!; there is no if_not_found.
#wildcard
2 tutorials tagged “wildcard”.
Excel How-to
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.