Help Centre › Building Processes
This article describes the RPA Excel functionality to find a value.
For a full list of available functions, please read EXCEL functions.
Description
The EXCEL Find a value function allows you to find a value.
Setting it up
To use the EXCEL Find a value function, follow these instructions:
{{popups:rpas/add:action=excel-find}}
Once on a process map:
- Navigate to the process where you would like to add the EXCEL Find a value function
- Click on the green button’s drop-down (right side of the green button labelled “Process”)
- On the menu that appears, click on the “+ Activity” item
- From here you can select the EXCEL Find a value option
- Click "Add" once you are done
Input parameters
| Parameter | Required | Type | Default | Description |
|---|---|---|---|---|
| File path | Yes | Text | – | Full path to the Excel file. |
| Sheet | Yes | Text | – | Name of the sheet to search. |
| Variable | Yes | Text | – | Variable to store the result. |
| Column | Yes | Text | – | Column name to search in. |
| Start row | No | Number | 1 | Row number to start searching from. |
| Conditions | Yes | Key-Value | – | Column / Operator / Value filter conditions. |
Output variables
| Variable | Type | Description |
|---|---|---|
| Variable | Text | The cell reference or value found. |
Errors
| Error | Description |
|---|---|
| Value not found | No matching value was found in the specified column. |
| Sheet not found | The specified sheet does not exist. |
Tips
- Combine multiple conditions to narrow down search results.
- Use the start row parameter to skip header rows.