5 Ways to Use Merge in Power Query & Make Your VLOOKUP Easier Than Ever

Подписаться 8 тыс.

Просмотров 4,1 тыс.

50% 1

VLOOKUP is hard and if you do not carefully follow it's rules and syntax, errors like #NA, #VALUE, #REF, and VLOOKUP returning incorrect results may occur. But it can be a lot easier and these common errors can be avoided! Once you learn how to use the Merge Queries function in Power Query you will never need to use VLOOKUP again. And your LOOKUP will be dynamic, watch this video to find out how.
Timestamps:
00:00 VLOOKUP Intro
00:21 Basic Merge Lookup Using Left Outer Join
04:45 How to Use Right Outer Join
06:40 How to Fix Merge Not Working
08:03 How to Return More than One Lookup Value
08:50 How to Perform Multiple Lookup Combinations
☕ If you would like to buy me a coffee, so I can get my caffeine in to keep creating as many videos as possible for you :). It's really quick and easy, please use this link: www.buymeacoffee.com/missmicr...
✅ For more videos please subscribe: / @missmicrosoft
✅ For more Power Query videos please use the links below:
Power Query in Excel Beginners Tutorial: Combine Multiple Excel Sheets, Automate & Transform Data: • Excel's Power Query: T...
Combine Data from Multiple Sheets into One Sheet in Excel: • Easiest Way to Combine...
✅ Please also check out my Excel course on Udemy, please use this link: www.udemy.com/course/excel-fo...

Опубликовано:

30 июл 2024

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист

Посмотреть позже

Комментарии : 16

@heishoi 5 месяцев назад

Wow ! this is awesome 👍👍👍

@MissMicrosoft 5 месяцев назад

Thank you so much 😊

@samalon3739 2 года назад

Thanks👍

@ronniebornman4122 2 года назад

Thanks! Great explanation…

@MissMicrosoft 2 года назад

You're most welcome Ronnie :)

@Faisal63045 2 года назад

Great

@MissMicrosoft 2 года назад

Glad you enjoyed it Faisal :)

@mehrdadazimi2298 7 месяцев назад

👍👍👍

@MissMicrosoft 7 месяцев назад

Thank you :)

@wayneedmondson1065 2 года назад

Very nice! Useful tips and well explained. Thanks for sharing your knowledge! Thumbs up!! PS - Some presenters share the example file to make it easier to follow along. I find it very helpful. Just an idea for your future videos. Cheers :))

@MissMicrosoft 2 года назад

Glad it was useful Wayne! I will definitely work on sharing the example file for future videos, thanks!

@jhanmichael31 2 года назад

Hi again, I can actually do this easily by following exact sample and scenario in your sample video. However, is it possible if I am working on a query and I wanted to do the vlookup the code from other source or other sheet? I was trying to do it by I failed. I am trying to find videos related to my query actually but so far yours is the closes one. Is there any possibility also to merge multiple Lists (more than 2)? because I want to do a vlookup not just from 1 list but also for other category list.

@MissMicrosoft 2 года назад

Hi @Jhan Michael, you can only merge two tables at a time in Power Query. For example if you have 3 tables, you could merge the first two tables and create a new table, the new table would be "Merge1" then use "Merge1" and merge it to your third table. The other option is to use Power Pivot.

@jhanmichael31 2 года назад

@@MissMicrosoft hi, yes somewhat I was able to manage it. It is really difficult to do trial and error if I am learning all by myself. I saw one of your video also on how to add macro/ Refresh Button. It was awesome. I am now using it. But, could you also create another video on how to generate an output file using macro after you got the result from power query?

@khalidmajeed2886 Год назад

how to use in multiple tables

@MissMicrosoft Год назад

Hi khalidmajeed, you can only merge two tables at a time in Power Query. For example if you have 3 tables, you could merge the first two tables and create a new table, the new table would be "Merge1" then use "Merge1" and merge it to your third table. The other option is to use Power Pivot.