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.