Vlookup

[leimst]

Hello,

I am brand new to PowerPivot and from what I've read, I understand that PowerPivot is great and much more efficient at performing the equivalent of an Excel VLOOKUP although there is no such function in PowerPivot?

I have 2 spreadsheets. I would like to bounce the smaller spreadsheet up against the larger and return the data from certain columns.

Can anyone tell me how to accomplish that?

Any help would be greatly appreciated!

Leimst

 

[masplin]

I have tried it myself but found this tutorial if it helps

http://javierguillen.wordpress.com/2012/02/10/simulating-an-approximate-match-vlookup-in-powerpivot/

Mike