Combine 2 IF and Search function

[Buddhika Rodrigo]

Dear all,
Please guys help me to categories following table's description into "Thread", "Care Label" and "Others". In the descriptions, if there are any words of Thread or care labels, should be categorized under thread or care labels but in the description there is no any marching name it should be categorized as "Other" I tried following formulas but I want to combine those to categorize this table
=IF(SEARCH("THREAD",A9),"THREAD"," ")
=IF(SEARCH("CARE LABLES",A13),"CARE LABLES"," ")

I appreciate if you help me to do this.

 

[Phuoc]

Try this

=LOOKUP(1,-SEARCH({"*","THREAD","CARE LABLES"},A9&" "),{"","THREAD","CARE LABLES"})

 

[Buddhika Rodrigo]

Try this

=LOOKUP(1,-SEARCH({"*","THREAD","CARE LABLES"},A9&" "),{"","THREAD","CARE LABLES"})

Thanks dude for your support. It is okay for some instance but How to categorizes "Others"? I tried your formula and the result as follows

 

[Phuoc]

=LOOKUP(1,-SEARCH({"*","THREAD","CARE LABLES"},A9&" "),{"Other","THREAD","CARE LABLES"})

 

[Buddhika Rodrigo]

=LOOKUP(1,-SEARCH({"*","THREAD","CARE LABLES"},A9&" "),{"Other","THREAD","CARE LABLES"})

thank you dude. I appreciate your support. this formula that I wanted.

 

[Peter_SSs]

thank you dude. I appreciate your support. this formula that I wanted.

The marked solution has been changed accordingly. In your future questions, please mark the post as the solution that actually answered your question, instead of your feedback message as it will help future readers. No further action is required for this thread.