Sample file: How to use wildcards with the XLOOKUP() function in Excel
This is the demonstration file to accompany the article, How to use wildcards with the XLOOKUP() function in Excel, by Susan Harkins.
From the intro of this Microsoft Excel tutorial:
Lookup functions are great for finding values that match another value. Thanks to XLOOKUP() this task is easier than ever, and it even supports wildcards! In this article, I’ll show you how to use the asterisk wildcard (*) to create a more flexible lookup value. Instead of finding an exact or almost match, dropping in a wildcard allows you to work with a simpler search string. This setup is helpful when you remember part of the search string, but not all of it. In this article, I’ll show you how to use a wildcard in the XOOKUP() function’s criteria argument, or search string.