Excel 2020: Speed Up VLOOKUP

October 26, 2020 - by Bill Jelen

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 Unsplash.com

This article is an excerpt from MrExcel 2020 - Seeing Excel Clearly.