Ever needed to use a VLOOKUP but don’t you know exactly how to spell what you are looking for, for example you may not remember how to spell a product name or the spelling of a Sales Person. Is it Josh Or Joseph?.
No worries though you can go a bit wild with the use of a wildcard.
Here’s an example to search for the Sales of the person whose name begins with Jos
As you can see VLOOKUP uses the wildcard to search for any sales person in Column C that begin with the letters Jos and returns their sales values.
Below are some more awesome uses of the wildcard with VLOOKUP using the same data set.
Do you think you would use wildcard in your VLOOKUP formula?