Excel 2007 : Currency Conversion

Currency Conversion example.xlsx

How do I auto calc the green cells?

Basically I have set up a data query from the MSN money website (Columns D-F) and have some amounts formatted as currencies and want to convert them to GBP amounts based on the appropriate currency conversion rate.

Need some sort of lookup into the table but I don't know how to lookup based on currency formats?

Thanks