#### KP_SoCal

##### Board Regular

- Joined
- Nov 17, 2009

- Messages
- 116

=SUMPRODUCT(

--(AllocatedVeh!$A$2:$A$65000=

__IF(Manifest!C8 = “TEXTILE”,AllocatedVeh!$A$2:$A$65000,Manifest!C8),__

--(AllocatedVeh!$C$2:$C$65000=Manifest!D8),

--(AllocatedVeh!$F$2:$F$65000=Manifest!G8)

,AllocatedVeh!$I$2:$I$65000)

However, I need to incorporate the SEARCH function into this formula. It works successfully when I'm NOT using the nested IF statement (see underlined above). The formula with the SEARCH function and WITHOUT the nested IF statement would look like this...

=SUMPRODUCT(

**--(ISNUMBER(SEARCH**(AllocatedVeh!$A$2:$A$65000,Manifest!C8))),

--(AllocatedVeh!$C$2:$C$65000=Manifest!D8),

--(AllocatedVeh!$F$2:$F$65000=Manifest!G8)

,AllocatedVeh!$I$2:$I$65000)

So my question is, how do I apply the logic from the formula directly above containing SEARCH function to the first formula I have listed containing the nested IF statement. Thanks so much for any suggestions on this!