PowerPivot and vlookup
I have a table full of sales data. Unfortunately, the data comes to me in "native" currencies. So, I'll have something like this:
Sale 1 - 15.00
Currency - USD
Sale 2 - 20
Currency - French Franc
I need to be able to convert the second sale, 20 in francs to USD.
in the "old days' I would have created a vlookup that compared the currency key column to a vlookup table, then found the relevant sales figure and multiplied by a conversion number.
Can't do this in powerpivot. I have setup my powerpivot tables so that the main table and the currency conversion table are related, but not sure what to do after that.