Search column for keyword to populate another column

[RodneyC]

Column A has about 7000 rows and I need to easily identify which of two categories items in these 7000 rows belong to and will designate this in Column B with either a “S” or a “L”.

To do so, I need a formula that will look in $A$2:$A$6441 for keywords. These keywords include Blowout, Escape, Public and a few others. If this keyword shows up in column A, I need “S” to show up in column B. If the keywords aren’t there, the cell should be populated with “L”

Thank you in advance

 

[Candyman8019]

Give this a try in column B:
=IF(OR($A$2:$A$6441={"Blowout","Escape","Public"}),"S","L")

 

[RodneyC]

Give this a try in column B:
=IF(OR($A$2:$A$6441={"Blowout","Escape","Public"}),"S","L")

We're making progress... I've tried that with a bit of a modification, I'm using this =IF(OR(A4={"Blowout","Escape","Public"}),"S","L") in B4 A4 does not include any of those values and as expected/wanted, L shows up in B4.

As I drag down to B5 the formula becomes =IF(OR(A5={"Blowout","Escape","Public"}),"S","L") A5 does include the value Blowout but B5 still displays an L as opposed to the desired S. I'm sure this is because A5 includes more than just the keyword Blowout. It actually says $4,000 Black Friday Cash Blowout and I modified the code to say =IF(OR(A5={"$4,000 Black Friday Cash Blowout","Escape","Public"}),"S","L") and it displayed the S as desired. Each of the cells with keywords such as "Blowout" actually contain multiple words and I'd prefer not to have to type every word from the cell, only a specific keyword.

Is that possible?

Thanks

 

[Fluff]

Another option

=SWITCH($A2,"Blowout","S","Escape","S","Public","S","L")

 

[Fluff]

As the words are part of the cell the formula in post#4 won't work.
Try

=IF(MAX(--ISNUMBER(SEARCH({"Blowout","Escape","Public"},A2)))>0,"S","L")

 

[RodneyC]

Thanks Fluff and Candyman. I ended up using Fluff's option and it worked perfectly. THANK YOU both.

 

[Fluff]

Glad we could help & thanks for the feedback.