How do I create an excel to calculate the different currencies based on 2 Inputs/Selection?

[winderkent]

Hi Fellow Excel Users,

I need some help on this and I can't wrap my head around it. I am trying to create a Forex Calculator based on the 2 inputs (highlighted in yellow in the image attached).

Based on the data validation, I have a FX table with GBP and USD rates.

Thanks

 

[Cubist]

1) Which version of Excel are you using?
2) You just need to do a lookup of the exchange rate of the input current to the desired currency so what does your exchange rate table look like?