Dear Analyst

The debate over VLOOKUP versus INDEX/MATCH in Excel


Listen Later


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. There is a huge debate over which method to use, and I break down the pros and cons of both methods. Long story short, I prefer using VLOOKUP due to its simplicity and the data sets I’m confronted with on a day-to-day basis.



In the 2nd half of the episode, I talk about some episodes from other podcasts I found interesting:



* My Side Project: Glide: David Siegel* The Tim Ferriss Show: Episode 364 – Safi Bahcall — On Thinking Big, Curing Cancer, and Transforming Industries* The Remote Show: Zack Onisko, CEO of Dribbble

...more
View all episodesView all episodes
Download on the App Store

Dear AnalystBy KeyCuts

  • 3.8
  • 3.8
  • 3.8
  • 3.8
  • 3.8

3.8

5 ratings