Xlookup vs Power Query Joins

Xlookup vs Power Query Joins

Three main differneces between using Power Query Joins and the new XLOOKUP function in Excel.

Xlookup vs Power Query Joins

The Excel file used in making of this YouTube tutorial.

A while back, I was talking about VLOOKUP alternatives, and even though everyone was focused on the VLOOKUP vs. INDEX&MATCH story, I proposed Power Query Joins were far superior to any function solutions in Excel. And then along came XLOOKUP. It was (out of the box) superior to VLOOKUP and INDEX MATCH combination. What about Power Query Joins. In this Video, I explore three reasons (or features) that still make Power Query Joins the most powerful solution for Joining two tables in Excel.