Deprecated: Creation of dynamic property ternplugin\youtube_video::$post is deprecated in /home1/cassanoc/public_html/bonbonsguide.com/wp/wp-content/plugins/automatic-video-posts/vendor/ternstyle/plugin/src/class/youtube_video.php on line 64

Excel Magic Trick 1508: Lookup In Current Table? Self Join? VLOOKUP or Power Query?

Posted on by Annie D

Download Files:
https://ift.tt/2KFamW4
https://ift.tt/2J0l187
https://ift.tt/2KEthR5

Entire page with all Excel Files for All Videos: https://ift.tt/1kSFWvs

In this video see how to lookup a referral ID in an employee table to return the employee name, but the catch is that the Lookup Return Column is in the Lookup Table. See how to do it in Excel with VLOOKUP and in Power Query with a Merge Left Outer Join that joins the employee table to itself.

Examples in this video:
1. (00:06) Introduction & Description of problem
2. (00:58) Excel VLOOKUP Example
3. (04:18) Power Query Example
4. (08:03) Summary

View on YouTube

Further Help

I offer limited consulting services to potentially assist you with data challenges, whether it's designing a complex Excel formula, writing a macro or building a whole new process for data capture, modeling and analysis.  Contact me if you have a need.