All Content
Timespan
explore our new search
​
I wrote 11 million formulas to find which one faster (XLOOKUP vs. INDEX MATCH)
Excel
Aug 2, 2022 12:00 AM

I wrote 11 million formulas to find which one faster (XLOOKUP vs. INDEX MATCH)

by HubSite 365 about Chandoo

Pro UserExcel

Ever wonder what is the fastest lookup function in Excel? In this experiment style video, I test VLOOKUP vs. INDEX+MATCH vs. XLOOKUP by writing 11 million formulas. The results are surprising!

Note: there is no sample file for this video (the dataset is rather large, but feel free to make some random data in Excel to test the concepts yourself).

  • Fastest lookup formula in Excel!
  • Dataset and testing methodology
  • Writing the VLOOKUP formula
  • INDEX MATCH formula
  • Faster INDEX MATCH formulas
  • XLOOKUP formula
  • The results (calculation time)
  • File size comparison
  • What does it all mean?