Types of wildcards to use with VLOOKUP
In Excel, wildcard characters are used to do partial matches *️⃣❔
Excel supports three different kinds of wildcard characters.
- Asterisk – *
- Question mark – ?
- Tilde – ~
All three of these wildcard character types are acceptable in a VLOOKUP function.
An asterisk wildcard character is used to represent any number of characters when doing a partial match.
For Example, Sp* could match Spreadsheeto, Special, Space, etc.
Question mark wild character represents any unknown single character.
For example, P?n will match Pan or Pen or Pin 🍳🖊️📍
The tilde wildcard character helps to remove the effect of other wildcard characters.
For Example, if you have to search exact match for “Excel*”, you have to enter “Excel~*”. Otherwise, you will get all words beginning with the word “Excel”.
You can learn how to use wildcards in VLOOKUP using the below Examples.