Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

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)
share|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
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

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

share|improve this answer

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

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