MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Excel 2019: Speed Up VLOOKUP

October 16, 2019 - by Bill Jelen

Speed Up VLOOKUP. Photo Credit: Alex Eckermann at

VLOOKUP is a relatively expensive function. When you are looking for an exact match, Excel has to look through the lookup table one row at a time. 

Previous editions of MrExcel LX – The Holy Grail of Excel Tips demonstrated a Charles Williams formula to make VLOOKUP faster. Starting in 2018, Office 365 includes a re-engineered VLOOKUP that is as fast as the Charles Williams trick.

=IF(VLOOKUP(A2,Table,1)=A2,VLOOKUP(A2,Table,1),"Not Found")

Title Photo: Alex Eckermann at

Bill Jelen is the author / co-author of
Microsoft Excel 2019 Pivot Table Data Crunching

Use Excel 2019 pivot tables and pivot charts to produce powerful, dynamic reports in minutes instead of hours, to take control of your data and your business. Even if you’ve never created a pivot table before, this book will help you leverage all their remarkable flexibility and analytical power–including valuable improvements in Excel 2019 and Excel in Office 365.