March 27, 2012

Rob Collie from PowerPivotPro: Does PowerPivot make VLOOKUP Obsolete?

By Bill Jelen

The first time that I saw PowerPivot create a pivot table from two worksheets WITHOUT doing any VLOOKUPs, I realized that a lot of people who thought VLOOKUP was scary would now be able to do some very powerful analyses. My favorite blog on PowerPivot is run by former Excel Project Manager Rob Collie. This morning, at 12:04AM, Rob checked in with a blog post that offers two amazing techniques:

  1. Joining two tables in PowerPivot using the Create Relationship dialog box
  2. Once you’ve joined two tables, using the DAX function =RELATED in the PowerPivot grid to replace VLOOKUP

Read Rob’s post, VLOOKUP Week – Who Needs VLOOKUPs Anymore.

About Bill Jelen

Author of 41 books about Microsoft Excel. View all posts by Bill Jelen
This entry was posted on Tuesday, March 27th, 2012 at 07:02 and tagged with , , , and posted in Uncategorized. You can follow any responses to this entry through the RSS 2.0 feed.

Leave a comment