XLOOKUP with Wildcard (Partial Match) in Microsoft #Excel 365=XLOOKUP("*"&B12&"*",Data[Fruits],Data[Codes],,2)