Why VLOOKUP when there is Power Query?

An icon that represents a date.
8 Feb
An icon of a clock.
8:30 pm
9:00 pm

About the session

For many years, VLOOKUP was the most used Excel resource to cross information between data sources. The capabilities of this function have made it possible to streamline processes that require comparing two data sets and cross information between them even when they are in separate files. Despite the power of this function, it also has serious limitations. Luckily, Excel has evolved tremendously in the past years, and we now have other tools to solve challenges where VLOOKUP would fall short. Power Query is one of those tools. We will compare the two in several scenarios to see which one would be a better option.

Register Interest


Our next event takes place in February 2025. Register your interest in attending and be the first to know when registration is live!