Use A Wildcard With A VLOOKUP Formula


Excel Dasboard Course

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

1523798

 

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.

 

1523812

 

 

 

 

Do you think you would use wildcard in your VLOOKUP formula?

 

More Excel Tips

YouTube Video- Create Your First Pivot Table

Fast Fun Way To Learn Excel Formulas

Easily Find Your Most Used Excel Workbook

Barbara

Barbara is an experienced data analyst with over 20 years of experience. Author of the How To Excel At Excel Top 50 Excel tips Ebook, YouTuber and Excel Blogger.

Recent Posts