How to Merge Excel Tables with Power Query: VLOOKUP Alternative

This video teaches you how to merge two tables or queries in Power Query to look up data and return matching results in Excel. The tables do not have to be formatted the same way. They just need to share one or more data categories. This is similar to Vlookup or Join where a relationship is created between two tables.