Javier Guillén “Simulates an “approximate match” VLOOKUP in PowerPivot”

Javier’s first entry begins:

“It is often said that relationships in PowerPivot work in a similar way to VLOOKUPs.  In reality, this is only partially true. If we examine the claim a bit closer we realize that Excel’s VLOOKUP function has a parameter in which it is possible to use an approximation when matching values against the lookup table…”  To Read More Click Here to go to Javier Guillén’s Lesson

 

You may find Javier on Twitter @javiguillen or at his blog Javier Guillén on WordPress

About MrExcel East

Facilitator | Image Virtuoso | Tweet-Jacker | Permuted Floridian | View all posts by MrExcel East

One response to “Javier Guillén “Simulates an “approximate match” VLOOKUP in PowerPivot”

  • John Bradley

    Absolutely brilliant. I have been looking for this solution since PowerPivot was first release. Great job! This will make my life much easier.

    Kind Regards,

    John Bradley

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

%d bloggers like this: