IF or TRUE statement for choosing the currency to calculate exchange rates

I have a table that I use for pricing calculations based on the currency since I tend to get get different products from different countries. There are different tables for the different currencies thatI tend to work with (i.e. USD, GBP, EUR etc) and then converted to local currency based on the exchange rates of the day. Taking a look at the top table (USD), you will see the sample rate (blue) for that day and it table calculates the cost in local currency. Now all the data in green in inputted automatically so that's not the issue. The challenge is finding a way or formula that can that different currencies in column C and uses an IF statement that takes USD and multiplies by value (rate) in blue (GBP-Yellow, EUR - Orange) and puts the value in column G (CIF). For instance

IF (currency=$), then C6*E$2$, IF(£) then yellow, IF(€) the orange) - or something like that.

I would even prefer to set up the currency options in column C as a pull down for those cells.

Any ideas?

when looking over your worksheet do you want the formula in column G to include sum(C6:F6)*(correct rate)
or just C6*(correct rate)

The formula should be SUM(C6:F6)*correct rate. E6 and F6 will be inputted manually while all areas in green will be locked. I was also think about adding another column with a pull down for currencies before the OEM cost (C) to see if an IF statement would be easier to use. See attached to for a better understanding