Buy Dideo Subscription
Sign up for our Excel webinar, times added weekly: https://www.excelcampus.com/blueprint-registration/ 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/vlookup-choose-vs-index-match/ 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: https://youtu.be/d3BYVQ6xIE4 XLOOKUP for Excel: Explained in 3 Minutes: https://www.youtube.com/watch?v=txK0C6SkaMg The New XLOOKUP Function: Compared to VLOOKUP & INDEX MATCH in Excel (more in depth explanation – 20 minutes): https://www.youtube.com/watch?v=pURSha68Mjs #MsExcel #ExcelCampus 00:00 Introduction 00:10 INDEX MATCH vs. VLOOKUP CHOOSE 00:39 Timing the Calculations
