up vote 1 down vote favorite
share [g+] share [fb]

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)
link|improve this question
Never mind, I figured out how to do this using VLookup. Thanks in every case. – Mustafa Ismail Mustafa Dec 27 '11 at 9:42
2  
If you have found it out on your own -- don't hesitate to write answer on your own. That would be benefitial for the potential visitors of this website who might face the same problem and find your question via a search engine! – Alexander Galkin Dec 27 '11 at 10:35
feedback

1 Answer

up vote 0 down vote

For your hidden values in USD (column D) you could use the formula =C1*vlookup(B1,sheet1!$A$1:$B$4,2,false) to multiply the value times the conversion rate on sheet 1 and drag it down column D on sheet 2

link|improve this answer
feedback

Your Answer

 
or
required, but never shown
discard

Not the answer you're looking for? Browse other questions tagged or ask your own question.