Description

The oldest, most common method of combining and comparing tables in Excel is use of the function VLOOKUP. In addition to this powerhouse, we have INDEX and MATCH, XLOOKUP, Power Query, and Power Pivot! In this session, you’ll see how these tools compare to one another and find a method that will work for you.

Topics include:

Using VLOOKUP to combine data from two lists

Leveraging INDEX and MATCH to handle complex lookup scenarios

Understanding XLOOKUP as a modern VLOOKUP replacement

Merging tables with Power Query

Creating relationships between tables with Power Pivot