I wrote 11 million formulas to find which one faster (XLOOKUP vs. INDEX MATCH)
von HubSite 365 über 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).