Using Switch and Contains for Multiple Conditions

Hello, 

I have a dataset with two specific columns, Marketing_grouping and campaign_name. I want to create a new column that reads the text string in the campaign_name column and returns a value. We want to identify if the campaign is a Brand or NonBrand campaign. There are other campaigns that are not Brand or Nonbrand specific, so if possible, the new column would return the Marketing grouping. Essentially we are splitting the Marketing_Grouping, Paid Search, into 2 groups, brand and nonbrand, and using the campaign name column to identify. Also, there are paid search campaigns that do no have brand or nonbrand in Its name and we will group them under nonbrand

** Case sensitive:

If campaign_name contains NB, Non, non, Non-Brand, and Marketing group = Paid Search, then NB 

If Campaign_Name contains Brand, BR, and marketing group = Paid Search, then Brand 

If Marketing_group = Paid Search and Campaign name doesn't contain any of the above, then NB 

Else, Marketing_Group (all other non paid search campaigns, use marketing group)