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