End of Excel VLOOKUPS – Power Pivot Relationships
Do you suffer from Excel VLOOKUP fatigue? The life of an Excel user inevitably involves combining data from various sources. And that, typically involves a generous use of VLOOKUPs.
We, at PowerPivotPro, argue that Excel is the best BI tool in the world; it’s our superhero (and of millions of business users who use it daily). However, the “old” Excel has some dark corners. For instance, the use of VLOOKUPs is problematic in cases such as