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