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 the more modern XLOOKUP, as well as the ability to create relationships with 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
- Understanding XLOOKUP as a modern VLOOKUP replacement
- Creating relationships between tables with Power Pivot