As with our previous series with Excel Vlookup, Xlookup and Index Match, this video covers an alternative to Vlookup that is especially helpful with Pivot Tables. In this example, we will define tables, join / relationships, data models and eventually pivot tables. We also add in pivot tables slicers to improve the pivot table style.