Site logo white shadow
Search

Power Query Merge – VLOOKUP alternative

Instead of VLOOKUP, you can use Power Query Merge. It is faster, more convenient and flexible. Learn how to do it. Watch 5 min video.

Power Query Merge Video

Download sample files

Contents

  1. The need – 00:00
  2. Vlookup problems – 00:35
  3. Power Pivot solution – 01:11
  4. Problem with data model approach – 01:25
  5. Solution: Use Power Query – 01:55
  6. Power Query Import – 02:16
  7. Merge queries – 02:44
  8. Merge Products – 03:34
  9. Add calculated column – 03:55
  10. Check data and import – 04:11
  11. Load To setting – 04:38

2 Responses

  1. Dear Sir
    Thanks for sharing
    Can U make Video on How to Increase Excel File speed ,
    Best Practices for Excel file to increase excel file speed ,
    When file Size Is large or Suggest Alternative to large Excel File eg List, MS access etc,

    Reply

Queries | Comments | Suggestions | Wish list

Subscribe to Blog

Join 1,749 other subscribers

Popular articles

1100+ in-depth blog articles

Microsoft 365 Copilot (Free Version) Masterclass

Use the power of Free Microsoft 365 Copilot to work more efficiently and grow faster in your career.

Excel to Power BI Course

Learn Power BI using the concepts you already know in Excel. Fast transition, in-depth coverage and immediately usable.

Excel Power BI Course Poster

Pivot Table Pro Course

Yes. You use Pivot Tables everyday. Now it is time to find out the real power and nuances. 5.5 hours video, exercises, samples, Q&A.