Help Centre › Functions & Formulas
Find values in a sheet containing a search term.
Add it to a process
In the process designer, open the Add step tab. Find Find values in a sheet containing a search term under Google Workspace › Sheets, or type its name in the search box, and drag it onto the canvas.
Fields
| Field | Required | What it does |
|---|---|---|
| Key | Yes | Text to search for |
| Range | Yes | Cell range to search within in A1 notation |
| Variable | No | Name of the variable where the result will be stored |
| Case sensitive | No | Whether the search is case-sensitive (default false) Default: off. |
See all Google Workspace steps.
Tips
- Use Match entire cell when searching for exact values like IDs
- The result array is empty if no matches are found
Related functions
- Find and replace – Find and replace values
- Read sheet range – Read a specific range