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.