Dear Analyst

Dear Analyst


The debate over VLOOKUP versus INDEX/MATCH in Excel

April 15, 2019

Should you use VLOOKUP or INDEX/MATCH in Excel? What are the pros and cons of each method? When you lookup data in Excel, you have the option to use either VLOOKUP or a combination of INDEX and MATCH functions.