Rob Collie from PowerPivotPro: Does PowerPivot make VLOOKUP Obsolete?

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 these ads

About Bill Jelen

Author of 31 books about Microsoft Excel. View all posts by Bill Jelen

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

Follow

Get every new post delivered to your Inbox.

Join 54 other followers

%d bloggers like this: