Formula is ignored in another Col has a key phrase

[batexcel]

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)

[AliGW]

If you have AA in N5 as a result of your long formula, how can the second formula produce BB-CC?

Anyway, you need this in P5:

=IF(D5="Do not Split",N5,your_formula)

[batexcel]

Hello, thank you.

The formula in Col O just takes everything from before the first "-" from the information in Col N so produces AA as that is before the first "-"


Thank you very much though!

[Pete_UK]

Couldn't you just use this in column O, i.e. in O5:

=LEFT(N5,FIND("-",N5)-1)

Hope this helps.

Pete

[batexcel]

Thanks Pete_UK - there's a couple of background things I need the formula in O to look at also so it's a bit longer