Search one column in a Google Sheet for a specific term. Be sure that the column you are searching has a value in every cell (even if it is 0); the search stops if it encounters a blank cell.
Options
- Spreadsheet (drop-down): list of spreadsheets in your Google Sheets account
- Worksheets (drop-down): list of worksheets in the spreadsheet
- Column to Search (drop-down): list of columns in the worksheet
Input
- Search Query
- Search Term (text): value that you want to search for in the column
Output
- Row Number (number): location number of the first row where the value was found (if the value is not found in the column, this field will return
null
)