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
Contents
- The need – 00:00
- Vlookup problems – 00:35
- Power Pivot solution – 01:11
- Problem with data model approach – 01:25
- Solution: Use Power Query – 01:55
- Power Query Import – 02:16
- Merge queries – 02:44
- Merge Products – 03:34
- Add calculated column – 03:55
- Check data and import – 04:11
- Load To setting – 04:38
2 Responses
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,
Large file handling, increase speed – Use data model – Watch this video – https://youtu.be/93h7rRsLF7Y