Coverting Based on Currency Sybol.

[Excel_77]

Hi All,

In column A I have a currency symbol, examples as below.

GBP
USD
CHF


In column B I have an amount within the currency outlined in column A.


1000
2000
3000

I have a separate tab called exchange rates for concerting currency into EUR so for example within this tab there are two columns

A - Currency e.g. GBP
B - Conversion rate e.g. 1.23


So what I want to do in the main tab within column C is search of the currency, link this to the currency within the "exchange rates" tab, return the rate and multiply this with the amount in column B to get the overall amount in Euro, how is this done?

Thanks

 

[wideboydixon]

In C1, for example:

=$B1*VLOOKUP($A1,Rates!$A:$B,2,FALSE)

WBD

 

[Excel_77]

Fantastic, works perfectly. Thanks so much.