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.