Excel VLOOKUP Wildcards: Partial Matching with Asterisk, Question Mark and Tilde
VLOOKUP supports wildcards for powerful partial-matching. Specifically, you can use the asterisk (*) for “any number of characters”, the question mark (?) for “exactly one character”, and the tilde (~) for wildcards literally. Consequently, this enables flexible lookups when exact keys don’t exist or vary in format.