Index Match Tutorial: Analytics in Excel series

Joins in Excel

The closest thing you can get in Excel to a SQL join is the Index Match function.  Vlookup is similar, and more popular, but worse in every way.  Index Match is easier, faster, and less prone to errors when you adjust your worksheet.

Index Match Tutorial

Check out the below video for a tutorial on how to perform Index Match and join your data.

https://youtu.be/TtUqDk8q340

Leave a Reply

Your email address will not be published. Required fields are marked *

X