changing the based currency from dropdown list

[zhuangzi]

HI, I have a financial statement spreadsheet where I enter the local currency in say Column B, and in Column C, I want it to reflect the US$ equivalent.

In Column E & F, it shows the various currency ISO code and to its right (Column F) the conversion rate to US$. I want to create a dropdown list of E& F, such that when I select a particular currency , Column C will take the value in B and convert it to US$ using the that particular exchange rate.

Can anyone teach me how this can be done?

Thanks.

 

[shift-del]

Hi

I assume the dropdown would be in column A.

=VLOOKUP(A2,E:F,2,FALSE)*B2

 

[hiker95]

zhuangzi,

See if this helps:
http://www.mrexcel.com/forum/showthread.php?t=539760


Currency Conversion Macro
This article presents a guide to using the "currency conversion" demo web service from within Microsoft Excel.
http://www.webcontinuum.net/ws_4.aspx