VLOOKUP (and now XLOOKUP) is one of the most popular functions in Excel. And we primarily use it to combine two tables. And most of us can agree that it takes time to get the hang of this formula. With Power Query, we can simplify this process using a feature called Merge Queries. It is equivalent to SQL JOINS. And Power Query offers six types of JOINS, which are simple to apply.
Related article:
VLOOKUP & JOINS using Power Query
Join the group BI Simplified to stay updated on future webinars and articles.