__S2__I'm trying to nest an IF(ISNUMBER(SEARCH statement and keep getting errors.

=IF(ISNUMBER(SEARCH(D2,D1)),P2,K2,IF(ISNUMBER(SEARCH(D2,D3)),"",O2))

What im trying to say is

If D2 is the same as D1 then P2 otherwise K2, If D2 is the same as D3 do nothing, otherwise O2,

For a better longer explanation, at the nd of each of my concatenates in column K and column P. There needs to be an

**END( which means F3 to execute the concatenate)**, that is hurting me, the

**END**can only be used at end of each truck number and no where in the middle, so i removed it from every concatenate and placed it in O2,(

**HIGHLIGHTED IN RED)**

My thought it that this formula will determine when a new truck number will begin and place the

**END**on the previous truck number

In this example D2 to D16 is all the same customer and If you look in Column A, they are all the same truck number.

For every first customer, K2 will begin the concatenate. If its the only customer, only K2 will be used for the customer in D2

but... if the customer has multiple lines, each additional line will come from P...P3&p4&p5&p6 etc once the last P is used... P16, O2 will be used (end)

Cell Formulas | ||
---|---|---|

Range | Formula | |

O2 | O2 | ="END" |

K2:K28 | K2 | ="010;"&TEXT(TODAY()+1,"yymmdd")&";"&A2&";01;Y;25;S;"&B2&";T1;16:30;" |

P2:P28 | P2 | ="S;"&B2&";T1;16:30;" |

S2 | S2 | =IF(ISNUMBER(SEARCH(D2,D1)),P2,K2)*(IF(ISNUMBER(SEARCH(D2,D3)),"",O2)) |

S3:S28 | S3 | =IF(ISNUMBER(SEARCH(D3,D2)),P3,K3) |