Been playing around with PowerPivot, which at a first glance, appears to be very powerful. But I'm struggling a bit.

So instead of vlookup I want to use the PowerPivot by creating relationships between 2 tables and then get the result in a "normal" pivot table by putting the match key in row label from table 1 and then the match values from table 2 in the values box.

All well and good. I have the match key in table 1 and table 2 which I then create a relationship between, but when I do the abovementioned it doesn't work. I get the same value from table 2 in all rows, so somehow the matching/relationship didn't work out.

Any ideas on how to approach this?