How To Easily Merge Tables With Power Query: Vlookup Alternative

Video Description

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