Excel 2019: Speed Up VLOOKUP
October 16, 2019 - 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.
Title Photo: Alex Eckermann at Unsplash.com