Vlookup in Power Query - How to lookup columns from other tables

In this video we will be showing how to lookup other columns in the Power Query Editor, similar to a VLOOKUP in Excel

I will be bringing your more and more content, please like and subscribe so you don't miss any.

Please suggest ideas for future videos that you need help with in the comments

[jkwa]

Thanks for posting this video! really helped me at work

[stephencross]

Very helpfull, but I find one of my answers are errors. The error message is
Expression.Error: There weren't enough elements in the enumeration to complete the operation.
Details:
[Table]

Do you know what this means and how to fix it?

[hongthuongtran]

what does it means for the 0 in the formulas?

[ommm]

Thanks, for some reason it was not working for me even thogh i have applied to the letter.! can you think of any reason why it would not work?

[mihaelavuc-vftt]

can you please paste the formula or explain the general criterias?

[jadellames]

Great video. But your audio is too low. I barely hear you even if I used my headset. I suggest if you can explain the concept behind your formula first before doing it. Illustration will be really helpful specially for visual learner like me. To be honest I barely understand what you do even if I repeat the video. Its probably due to my lack of knowledge. But tutorial are made for dumb people like me so please make your video easier to understand. Thanks