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

Lookup has two different usage:

Lookup( value, array )


Lookup( value, lookup_range, result_range )

I want to return more than one cell when it found the value. Like:


C column has its price, D Colum has its currency. And i want to multiply price with local currency to show everything in one currency.

How can i take the results one by one ?

A          B            C           D
Product1   xxxx         10          €
Product2   xxxx         5           $

C and D will return but how can i access them?

share|improve this question

Depends on how you want it returned. If you want it returned as a concatenated field you can do something like this:


Or if you want to return it into two different cells you could use the two formulas seperately:


Edit: If you tell us a little more about where and how you are storing your exchange rates, we could use those to turn everything into US Dollars also using a lookup.

share|improve this answer

See if this works:

=LOOKUP(A17;'Products'!A:A;'Products'!C:C) * LOOKUP(A17;'Products'!A:A;'Products'!D:D)
share|improve this answer
according to the question, it seems that column D is not the exchange rate – wilson Aug 20 '10 at 2:43

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.