Easy Excel Hacks: Two-Column Lookups with Power Query

If you worked with lookup functions like VLOOKUP or INDEX/MATCH, you now it can't natively perform multiple column lookups unless you add a helper column that concatenates values. the unlock the secrets of Excel with this easy hack on two-column lookups using Power Query. This essential skill, perfect for enhancing your data manipulation and analysis capabilities, is broken down into simple, actionable steps. This tutorial is designed to take you from the fundamentals to advanced applications, ensuring you grasp the technique. Check it out!
If you want to see how it's done with Excel functions here's another video • Perform a Two Column L...
🔔 SUBSCRIBE to my channel ➜ goo.gl/wN3c3p
🏫 Excel Training ➜ www.exceltrain...
📚 Excel Books & Tech Gear ➜ www.amazon.com...
⚙️ Tools: Screencasting ➜ techsmith.z6rj...
⚙️ Tools: Microsoft Office ➜ microsoft.msaf...
⚙️ Tools: TubeBuddy ➜ www.tubebuddy....
📝 This description may contain affiliate links and we'll receive a small commission if a purchased is made using the links (but at no additional cost to you). It'll support the channel and so more videos like this can be made. Thanks for your support!
🎁 If you find these videos useful and want to support my channel go to / doughexcel
#excel
#msexcel
#doughexcel
~-~~-~~~-~~-~
Please watch: "Convert Table in a PDF File to Excel"
• Convert Table in a PDF...
~-~~-~~~-~~-~