Hello,

In Col N I have information, for example

AA-BB-CC
CC-DD-EE
FFF-G-HHH


In Col O I have this formula;
=IFERROR(IFERROR(INDEX(LISTS!S$2:S$10351,AGGREGATE(15,6,MATCH(LEFT(N6,ROW(INDIRECT("1:"&LEN(N6)))),LISTS!S$2:S$10351,),1)),LEFT(N6,FIND("-",N6)-1)),"")

And the causes the data from Col N to look like

AA
CC
FFF


In Col P I have this formula
=SUBSTITUTE(N5,O5&"-","")

And this causes the data to look like
BB-CC
DD-EE
G-HHH


However, basically, what I need is when Col D has the phrase 'Do not Split' the information in Col N is simply replicated in Col P (I have about 50 potential phrases in Col D and they all require the information being split up)