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)