If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Trying to lookup based on a condition of two values
I have three columns A, B and C.
I want too look up the value in C where A and B match different values. Example: A, B ,C apple, color, green apple , price, 30 lemon, taste, tangy lemon, price 20 I want to lookup A=apple B=price to return the price 30. |
#2
|
|||
|
|||
Trying to lookup based on a condition of two values
Assuming that the combination of A + B is unique...
=SUMPRODUCT(--(A2:A10="apple"),--(B2:B10="price"),C2:C10) Better to use cells to hold the criteria. E2 = apple F2 = price =SUMPRODUCT(--(A2:A10=E2),--(B2:B10=F2),C2:C10) -- Biff Microsoft Excel MVP "Trying to lookup based on a condition of" Trying to lookup based on a condition wrote in message ... I have three columns A, B and C. I want too look up the value in C where A and B match different values. Example: A, B ,C apple, color, green apple , price, 30 lemon, taste, tangy lemon, price 20 I want to lookup A=apple B=price to return the price 30. |
Thread Tools | |
Display Modes | |
|
|