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).