Trying to lookup based on a condition of two values

[Trying to lookup based on a condition of]

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.

 

[T. Valko]

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 (e-mail address removed)> wrote in message
news:[email protected]...