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?