The debate over VLOOKUP versus INDEX/MATCH in Excel
Podcast: Play in new window | Download
Subscribe: Spotify | TuneIn | RSS
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
Trackbacks/Pingbacks
[…] overcome this issue with how your data is structured. Notably, the INDEX/MATCH strategy is the most commonly-cited strategy when good ‘ol VLOOKUP is not at your disposal. In this episode I walk through a strategy that […]
[…] a powerful formula for finding the data you need in a long list. Comparable formulas include the combination of INDEX and MATCH and the new XLOOKUP formula which took the Excel world by storm. One common task you might need to […]