excel - recalculate currency by selection curency symbol from drop down box -

Every time I select the currency from the user drop down box, the value needs to be re-calculated .

Example <

column A column B product 1 25 product 2 34 product 3 16

Assuming that the value in column B is in the euro, There is a need to create a drop down box that includes Euro, USD, GBP and so on. Every time I select a currency from the drop down list, then I want Column B to recalculate on the basis of the currency rate between the euro and the selected currency.

Any ideas how to do that?

Add a column for the converted values, which is counted as the Euro value (column) E1