Excel Lookups and Relationships - Seminar
Lookup Functions and Table Relationship in Excel
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