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)
Bookmarks