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