Crucial Power Query with Two Way Lookup – 2296

How to do a two-way lookup during import in Excel Power Query.
Sweeps URL: https://ift.tt/2NRz7gu
Recorded at Ignite 2019 in Orlando, this video shows you how to do a two-way lookup when merging files in Power Query – even if the fields are in the “wrong” order.

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.