You can use wildcards with the XLOOKUP() function in Excel to find matches even when you don’t know the exact value you’re looking for
The XLOOKUP() function in Excel lets you search for an exact match on an entire column or row of data,...
xlookup not working with text
