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

[@heishoi]

Wow ! this is awesome 👍👍👍

[@MissMicrosoft]

Thank you so much 😊

[@ronniebornman4122]

Thanks! Great explanation…

[@MissMicrosoft]

You're most welcome Ronnie :)

[@samalon3739]

Thanks👍

[@wayneedmondson1065]

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]

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

[@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.

[@jhanmichael31]

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]

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]

@@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?

[@Faisal63045]

Great

[@MissMicrosoft]

Glad you enjoyed it Faisal :)

[@mehrdadazimi2298]

👍👍👍

[@MissMicrosoft]

Thank you :)