Excel SEARCH Function Multiple Values (3 examples)

Excel SEARCH Function Multiple Values

In Excel SEARCH Function Multiple Values, users can search for multiple values in a cell. Here are three examples on how to use SEARCH for multiple values.

Example 1: SEARCH Function to search for multiple values:

In our example, we want to test whether some text are present in our cells, and the formula is =IF(COUNT(SEARCH({“Messi”,”best”,”player”,”Ling”,”Success”}, C6)), 1, “0”), which returns 1 if SEARCH function finds the text in the cell; otherwise, it returns 0 (zero).

Example 2: SEARCH Function to search for multiple value and return TRUE/FALSE:

To test for presence of value(s) in a cell and return TRUE/FALSE, the formula is =SUMPRODUCT(–ISNUMBER(SEARCH({“orange”,”apple”,”Banana”,”Cheese”,”Book”},C6)))=2.

Example 3: SEARCH Function to search for multiple values in a list:

If users want to search for multiple values in a list, they can use the formula like

More related readings:

1. MS office post on SEARCH Function
2. Extract first Name in excel (3 practical examples)
3. Extract Middle names (3 practical examples)
4. Excel ARRAYTOTEXT Function
5. Excel CLEAN Function with practical examples
6. Excel CONCAT Function to join text
7. Excel REPLACE Function to replace text
8. Excel TRIM Function with Practical Examples
9. Get Name from email address