MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Excel 2019: Use a Wildcard in VLOOKUP


August 08, 2019 - by Bill Jelen

Excel Use a Wildcard in VLOOKUP. Photo Credit: Josh Appel at Unsplash.com

You can do a sort of fuzzy match with VLOOKUP. If you aren‘t sure if your lookup table will contain Apple, Apple Computer, or Apple Computer Inc, you can use =VLOOKUP("Apple*",Table,2,False), and Excel will find the first item in the lookup table that starts with Apple.


Thanks to -Khalif John Clark.

Tip

Microsoft Labs offers a free Fuzzy Lookup add-in for Excel. See Excel 2019: Use the Fuzzy Lookup Tool from Microsoft Labs

Title Photo: Josh Appel at Unsplash.com


Bill Jelen is the author / co-author of
MrExcel LX – The Holy Grail of Excel Tips

A book for people who use Excel 40+ hours per week. Illustrated in full color.