Microsoft Excel’s XLOOKUP() is powerful, but combined with wildcards, it’s also flexible. Lookup functions are great for finding values that match another value. Thanks to XLOOKUP() this task is ...