Replacing VLOOKUP with Power Query Outer Joins | Everyday Office

[@Muuip]

Power Query is also much faster than VLOOKUP when dealing with 500k unique rows! 👍👍👍

[@MrDhunpagla]

It is awesome....& like the way you represented ....Nice...Let's have more please 👍👌

[@jayxpea]

Once you remove a column in power query how do you get it back if further down the track i.e. you decide you need the region column again?

[@KnackTraining]

Find the step on your right-hand panel where you removed the column, and get rid of it (click the X icon).

[@nurhanaabdghani35]

How do you save this query for usage next time?

[@hernanperez912]

Wow! Brilliant man... Thanks

[@soaringeagle7605]

Very helpful. Thanks!

[@loismathius8747]

Very clear explanation, love it!