VLookup Workbook (preview)

VLookup Workbook activity that finds a value in the first column of a table range using the Excel VLOOKUP function and returns a value from another column.

UiPath.Excel.Activities.VLookup

Description

Looks up a value in the first column of a table range and returns a value from the column that you specify, using the Excel VLOOKUP function. This is the cross-platform equivalent of the VLookup Windows activity.

Note:

This activity does not support .xls files.

Project compatibility

Windows | Cross-platform

Properties

Common

• DisplayName - The name displayed for the activity in the Designer panel.

Input

• File - The full path of the resource workbook. To switch to a local path, select the plus icon, and then Use Local File. The current field changes to File (local path), where you can provide the full path of the workbook.
• SheetName - The name of the sheet from the workbook.
• Table Range - The table range to search. The activity searches the first column of the range. This field is required.
• Lookup Value - The value to search for. This field is required.
• Column Index - The 1-based index of the column, within the table range, to return a value from. Column 1 is the first column of the range, the one that is searched. This field is required.

Options

• Exact Match - Select this option for an exact match. Clear it for an approximate match against sorted data, which finds the nearest value that is less than or equal to the lookup value. By default, this option is selected.
• Password - The password of the workbook, if necessary.

Output

• Result - The value that the activity found, or null if the lookup value is not found. You can store the value in a variable of any type. The value is converted if the type is different.

Use Workbook

• Workbook - The existing workbook to use instead of a file path.

Notes

• For an approximate match, the first column of the table range must be sorted in ascending order, as in the Excel VLOOKUP function.
• Table Range must refer to the sheet in SheetName. A range that includes a sheet name, such as Sheet2!A1:C100, is not supported and causes an error.
• A whole-column or whole-row range, such as A:C, is limited to the used range of the sheet.
• The activity fails with an error if Table Range is empty, if Column Index is less than 1 or greater than the number of columns in the range, or if Lookup Value is null.