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.
|Spreadsheet||List of spreadsheets in your Google Sheets account||Dropdown||TRUE|
|Worksheets||List of worksheets in the spreadsheet||Dropdown||TRUE|
|Column to Search||List of columns in the worksheet||Dropdown||TRUE|
|Search Term||Value that you want to search for in the column||String||FALSE|
|Row 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
|Rows||A list containing the row numbers where the value was found. Returned when