XLOOKUP match text contains
Learn how to use XLOOKUP to match text values with the help of the 5th argument, wildcard character match mode. How to lookup matching text values One of the powerful features of the XLOOKUP function is the native wildcards support. You enable wildcards, locate the 5th argument (match mode), and set the parameter to 2. … Read more