The source code for this is in 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)
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) |