Sep 11, 2022 12:00 AM

XLOOKUP v Power Query v Power Pivot in Excel

External YouTube Channel

When combining tables in Excel there are several options. Here I show you XLOOKUP, Power Query Merge and a Power Pivot relationship.

More about Excel Features

What are the XLOOKUP & VLOOKUP functions in Excel?

The XLOOKUP and VLOOKUP functions in Excel are used to find, or 'lookup', a value from a table or a list and then return a related result. In this resource, we’ll discuss XLOOKUP vs VLOOKUP with examples of how to use each.

XLOOKUP just killed VLOOKUP: everything to know about this major new Excel function

Microsoft recently announced the upcoming release of a new function called XLOOKUP. This function will be replacing the widely used VLOOKUP, HLOOKUP and INDEX/MATCH functions to run searches in a table of Excel data.