Lookup based on 2 conditions?

  • Thread starter Thread starter Gary
  • Start date Start date
G

Gary

How do I lookup a value in column 3 based on values in both columns 1
and 2? All the functions in Excel seem to allow only one condition.
 
I don't think the SUMPRODUCT approach works because you can't do
multiplication with a boolean value.

I've come up with this array formula approach:

=SUM(C2:C32766*IF(A2:A32766="Condition1",1,0)*IF(B2:B32766="Condition2",1,0))
 
Gary said:
I don't think the SUMPRODUCT approach works because you can't do
multiplication with a boolean value.
Click to expand...

Where did you get that from? 1 times TRUE is 1 and 1 times FALSE is 0

no need to involve IF in this

Regards,

Peo Sjoblom
 
Gary,

Not sure what you mean that you can't multiply with 1 & 0 (Boolean values).
Last I looked those numbers worked just like the rest of the Real numbers.

PC
 
Gary,

Copy & paste the exact formula you are using and also give an example of
your data set. (2 or three lines should be sufficient.)

PC
 
Back
Top