Super User is a question and answer site for computer enthusiasts and power users. Join them; it only takes a minute:

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 )

and

Lookup( value, lookup_range, result_range )

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

=LOOKUP(A17;'Products'!A:A;'Products'!C:D)

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:

=LOOKUP(A17;'Products'!A:A;'Products'!C:C)&LOOKUP(A17;'Products'!A:A;'Products'!D:D)

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

=LOOKUP(A17;'Products'!A:A;'Products'!C:C)
=LOOKUP(A17;'Products'!A:A;'Products'!D:D)

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
1  
according to the question, it seems that column D is not the exchange rate – wilson Aug 20 '10 at 2:43

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .