VLOOKUP supports wildcards for powerful partial-matching: use the asterisk (*) for “any number of characters”, the question mark (?) for “exactly one character”, and the tilde (~) to treat wildcards literally, enabling flexible lookups when exact keys don’t exist or vary in format.
