If one column has X, then replace all instances of (a word) in another column

[thankyou]

Your help would be so appreciated if you feel it, thank you.

If Column "E" has an "S" or "U+U" in the cell, then REPLACE the instance of "Favorites" in that row's Column I with:

"FAVORITES 1 (Solos/OCs/twins only)" Similarly, If Column "E" has an "D" in the cell, then REPLACE the instance of "Favorites" in that row's Column I with: [TABLE="width: 255"] <tbody>[TR] [TD="width: 255"]"FAVORITES 2 (Duets only)" thank you for your consideration <tbody> </tbody>

<tbody>
</tbody>

[/TD]
[/TR]
</tbody>[/TABLE]

 

[KolGuyXcel]

=IF(OR(NOT(ISERROR(SEARCH("*S*",E2))),NOT(ISERROR(SEARCH("*U+U*",E2)))),SUBSTITUTE(I2,"Favorites","FAVORITES 1 (Solos/OCs/twins only)"),IF(NOT(ISERROR(SEARCH("*D*",E2))),SUBSTITUTE(I2,"Favorites","FAVORITES 2 (Duets only)")))

 

[thankyou]

Re: If one column has X, then replace all instances of (a word) in another column - SOLVED

=IF(OR(NOT(ISERROR(SEARCH("*S*",E2))),NOT(ISERROR(SEARCH("*U+U*",E2)))),SUBSTITUTE(I2,"Favorites","FAVORITES 1 (Solos/OCs/twins only)"),IF(NOT(ISERROR(SEARCH("*D*",E2))),SUBSTITUTE(I2,"Favorites","FAVORITES 2 (Duets only)")))

Pretty brilliant brother. Worked like a charm and saved me a ton of time, but mostly, totally saved my a*s. Thanks big-time for helping out.

SOLVED, thanks to KolGuyXcel