Say I have two columns, the currency and the exchange rate and on another sheet in the same workbook, I'm referencing the currency as a drop down list. I want to be able to pull the value of the exchange rate, which is in another column and plug that into a formula.
To add to that, the values, normalized at one currency, is then summed.
Currency Exchange Rate to USD USD 1 EUR 1.307 JOD 3.59 KWD 1.41
And the desired output:
Expense Currency Value Value(USD)(Invisible) X USD 1000 1000 Y EUR 4321 5647.55 Z KWD 1000 3590 Total 10237.55 (always calculated in USD, the nominal currency)