Buddhika Rodrigo
New Member
- Joined
- Nov 22, 2023
- Messages
- 4
- Office Version
- 2016
- 2010
- 2003 or older
- Platform
- Windows
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.
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.