Speedy lookups

Monitor showing a worksheet with a speedometer in the lower right corner

Have you ever used VLOOKUP, HLOOKUP, or MATCH to find an exact match in unsorted data? If so, you might have noticed that it took a little while. However, in this update of Excel, you'll notice these calculations are noticeably faster.

For example, in a previous version of Excel, we found five VLOOKUP formulas that took 37 seconds to calculate. But in this update, the same calculation took only take 12 seconds. That's approximately a 67% reduction in calculation time!

There are other performance improvements in this update as well. Read more about these improvements here.

Expand your Office skills
Explore training
Get new features first
Join Office Insiders

Was this information helpful?

Thank you for your feedback!

Thank you for your feedback! It sounds like it might be helpful to connect you to one of our Office support agents.