Excel: Searching for multiple terms in a cell

by

Another way

=IF(SUMPRODUCT(--(NOT(ISERR(SEARCH({"Gingrich","Obama","Romney"},C1)))))>0,"1","")

Also, if you keep a list of values in, say A1 to A3, then you can use

=IF(SUMPRODUCT(--(NOT(ISERR(SEARCH($A$1:$A$3,C1)))))>0,"1","")

The wildcards are not necessary at all in the Search() function, since Search() returns the position of the found string.

More Related Contents:

  1. filter out multiple criteria using excel vba
  2. Ignore Duplicates and Create New List of Unique Values in Excel
  3. Remove leading or trailing spaces in an entire column of data
  4. If two cells match, return value from third
  5. Optimizing Excel formulas – SUMPRODUCT vs SUMIFS/COUNTIFS
  6. Cannot VBA write data to cells in Excel 2007/2010 within a function
  7. Excel: the Incredible Shrinking and Expanding Controls [closed]
  8. Extract the last substring from a cell
  9. VBA – How to grab the cell below if a cell has text?
  10. Excel formula checklist in employees
  11. Excel VBA – How to add dynamic array formula
  12. TEXTJOIN for xl2010/xl2013 with criteria
  13. What is the difference between “Form Controls” and “ActiveX Control” in Excel 2010?
  14. Difference between date and time w/out work week Excel
  15. Excel Formula for Inventory
  16. Count Unique values with a condition
  17. Count unique values in Excel
  18. How do I apply a SumIf Formula in a VBA Sub? Getting Error 1004
  19. Using the value in a cell as a cell reference in a formula?
  20. Excel – extracting top 5 values
  21. Importing CSV with line breaks in Excel 2007
  22. Excel VBA to match and line up rows
  23. CountIf With Filtered Data
  24. How to count cells in a range with a value less than another cell in excel?
  25. How to extract text within a string of text
  26. Excel: How to gather unique values in one column that are associated with duplicates in another column?
  27. Date-Formatting in TEXT formula independent from used language in Excel
  28. Check whether a cell contains a substring
  29. Get content of a cell given the row and column numbers
  30. How does one restore default case to a variable in VBA (Excel 2010)?

Leave a Comment