Search Rows by Column
Search for a row or rows that match a value in a certain column.
Options
-
Workbook(dropdown): a list of workbooks available to the account. Workbook is another word for your Excel files.
-
Worksheet(dropdown): a list of worksheets available in the selected workbook. Worksheet is the individual spreadsheet within them, displayed as tabs in Excel files.
-
Column to Search(dropdown) : The column the search will be conducted on.
-
Result Set(dropdown) : either the first matching row or all matching rows.
Input Fields
-
Column
- Value(text) : The column value. This is the number displayed in Excel on the top of first row.
Output Fields
- Result : rows that are search for.