Help Centre › Building Processes
This article describes the RPA Excel functionality to lookup column values.
For a full list of available functions, please read EXCEL functions.
Description
The EXCEL Lookup column values function allows you to lookup column values.
Setting it up
To use the EXCEL Lookup column values function, follow these instructions:
{{popups:rpas/add:action=excel-lookup}}
Once on a process map:
- Navigate to the process where you would like to add the EXCEL Lookup column values 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 Lookup column values option
- Click "Add" once you are done
Input parameters
| Parameter | Required | Type | Default | Description |
|---|---|---|---|---|
| Sheet | Yes | Text | - | The name of the target sheet |
| Column | Yes | Text | - | The key column to match on |
| Source path | Yes | Text | - | The file path of the source workbook |
| Source sheet | Yes | Text | - | The sheet name in the source workbook |
| Source column | Yes | Text | - | The key column in the source workbook |
| Column mapping | Yes | Table | - | Mapping of source columns to target columns |
Output variables
This action does not produce output variables.
Errors
| Error | Description |
|---|---|
| File not open | The Excel file must be open |
| Sheet not found | The specified sheet does not exist |
| Source file not found | The source file does not exist |
Tips
- Similar to VLOOKUP but across workbooks
- Matches rows by the key column and copies mapped column values