Trying to lookup based on a condition of two values

  • Thread starter Thread starter Trying to lookup based on a condition of
  • Start date Start date
T

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.
 
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]...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Help with =SUMPRODUCT 3
Stripe out duplicate data 5
Excel Lookup 1
match, lookup two column data 10
With F1 value, look at A, if match or partial match return B 5
min in a subgroup 9
using dates for lookup 2
Lookup Value 2

Back
Top