A number of 'Excel if cells contains' formula examples show how to return some value in another column if a target cell contains specific text, any text, any number or any value at all (not empty cell), test multiple criteria with OR as well as AND logic.
Excel formula: If cell contains - Excelchat
Count the Number of Cells that Contain Specific Text in Excel
How to Lookup Multiple Corresponding Values in Excel Using INDEX and SMALL Functions, PDF, Database Index
/smi/examples/contains-specific
Excel: Apply Conditional Formatting if Cell Contains Partial Text
Excel: If cell contains formula examples
Excel Logical Functions: Guide To Topics: For A Result That Is A Logical Value (True or False) Use
Excel IFERROR Function: Example #1, PDF, Database Index
Check IF a Cell Value is a Number (Excel Formula)
Count Unique Values in Excel: Criteria and Blanks