Sign up for our Excel webinar, times added weekly: https://www.excelcampus.com/blueprint-registration/
This video teaches you how to merge two tables or queries in Power Query to look up data and return matching results. 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.

The Merge feature of Power Query works the same in both Excel and Power BI.

You can download the sample Excel file on the accompanying blog post: https://www.excelcampus.com/powerquery/power-query-merge-vlookup

Related Videos:

How to Combine Excel Tables or Worksheets with Power Query: https://www.youtube.com/watch?v=HcfKOusOJhA
Power Query Overview - Automate Data Tasks in Excel & Power BI: https://www.youtube.com/watch?v=vq9AgAtSvQg

How to Install Power Query in Excel 2010 or 2013 for Windows: https://www.youtube.com/watch?v=gwW2CDdvUUs

VLOOKUP Tutorial: Everything you need to know: https://youtu.be/d3BYVQ6xIE4

Webinar: Free Excel Training on The Modern Power Tools
Want to learn more about Power Query, Power Pivot, Power BI, pivot tables, and macros & VBA. Checkout my free webinar where I explain how these tools can fit into your workflow to save you a ton of time with your job and help you become the Excel Hero of your organization. Click the link below to reserve your spot. It's free!
https://excelcampus.easywebinar.live/registration-blueprint


#MsExcel #ExcelCampus
00:00 Introduction
02:21 Merge with VLOOKUP
05:12 Fix Blank Rows