Sign up for our Excel webinar, times added weekly: https://www.excelcampus.com/blueprint...
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/powerquer...

Related Videos:

How to Combine Excel Tables or Worksheets with Power Query:    • How To Combine Excel Tables And Works...  
Power Query Overview Automate Data Tasks in Excel & Power BI:    • How To Automate Data Tasks In Excel U...  

How to Install Power Query in Excel 2010 or 2013 for Windows:    • How To Install Power Query For Excel ...  

VLOOKUP Tutorial: Everything you need to know:    • Excel Vlookup Tutorial  Everything Y...  

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/...


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