Excel Performance Test: Vlookup Vs Index Match

Sign up for our Excel webinar, times added weekly: https://www.excelcampus.com/blueprint...
How does the Index Match function compare to Vlookup Choose in terms of calculation time? I ran a series of tests to compare the two and found that there is a very clear winner.
If you’d like to run these tests for yourself, you can use the worksheet I’ve already set up. You can download it here: https://www.excelcampus.com/functions...

I ran three tests, with the formulas in 50,000 cells and changed the size of the lookup table for each test.

--Test #1: Match vs. Choose with a lookup table of 500 rows 0:15
--Test #2: Match vs. Choose with a lookup table of 5,000 rows 2:25
--Test #3: Match vs. Choose using whole column references 4:20

If you’d like to see me test and compare other functions and formulas, please leave a comment below.

Additional Resources:
VLOOKUP Tutorial for Excel:    • Excel Vlookup Tutorial - Everything You Ne...  
XLOOKUP for Excel: Explained in 3 Minutes:    • Xlookup In Excel: Explained In 3 Minutes  
The New XLOOKUP Function: Compared to VLOOKUP & INDEX MATCH in Excel (more in depth explanation – 20 minutes):    • New Xlookup Function: A Vlookup Comparison  


#MsExcel #ExcelCampus
00:00 Introduction
00:10 INDEX MATCH vs. VLOOKUP CHOOSE
00:39 Timing the Calculations