Table of Contents
The SEARCH function in Google Sheets allows users to search for specific values within a range of cells. This function can be used with multiple values by separating them with a comma within the formula. This allows for efficient and accurate searching of data within a large dataset. By using the SEARCH function with multiple values, users can quickly identify and extract the desired information from their spreadsheet. This feature is particularly useful for organizing and analyzing data in a systematic manner.
Google Sheets: Use SEARCH with Multiple Values
You can use the following basic syntax to use the SEARCH function with multiple values in Google Sheets:
=FILTER(A2:A10, SEARCH("Backup", A2:A10), SEARCH("Guard", A2:A10))
This particular example will return all cells in the range A2:A10 that contain both the string “Backup” and “Guard” somewhere in the cell.
The following example shows how to use this syntax in practice.
Example: Using SEARCH with Multiple Values in Google Sheets
Suppose we have the following dataset in Google Sheets that contains information about various basketball players:
Now suppose we would like to find all cells in the Position column that contain both the word “Backup” and “Guard” somewhere in the cell.
We can type the following formula into cell D1 to find each of these cells:
=FILTER(A2:A10, SEARCH("Backup", A2:A10), SEARCH("Guard", A2:A10))The following screenshot shows how to use this formula in practice:
The formula correctly returns the three cells that each contain the word “Backup” and “Guard” somewhere in the cell.
If you’d like to return the values in the points column for each of these players as well, simply change the filter range from A2:A10 to A2:B10 as follows:
=FILTER(A2:B10, SEARCH("Backup", A2:A10), SEARCH("Guard", A2:A10))The following screenshot shows how to use this formula in practice:
Cite this article
stats writer (2024). How can I use the SEARCH function in Google Sheets with multiple values?. PSYCHOLOGICAL SCALES. Retrieved from https://scales.arabpsychology.com/stats/how-can-i-use-the-search-function-in-google-sheets-with-multiple-values/
stats writer. "How can I use the SEARCH function in Google Sheets with multiple values?." PSYCHOLOGICAL SCALES, 25 Jun. 2024, https://scales.arabpsychology.com/stats/how-can-i-use-the-search-function-in-google-sheets-with-multiple-values/.
stats writer. "How can I use the SEARCH function in Google Sheets with multiple values?." PSYCHOLOGICAL SCALES, 2024. https://scales.arabpsychology.com/stats/how-can-i-use-the-search-function-in-google-sheets-with-multiple-values/.
stats writer (2024) 'How can I use the SEARCH function in Google Sheets with multiple values?', PSYCHOLOGICAL SCALES. Available at: https://scales.arabpsychology.com/stats/how-can-i-use-the-search-function-in-google-sheets-with-multiple-values/.
[1] stats writer, "How can I use the SEARCH function in Google Sheets with multiple values?," PSYCHOLOGICAL SCALES, vol. X, no. Y, ص Z-Z, June, 2024.
stats writer. How can I use the SEARCH function in Google Sheets with multiple values?. PSYCHOLOGICAL SCALES. 2024;vol(issue):pages.