# VLookup

> `UiPath.Excel.Activities.Business.VLookupX`

`UiPath.Excel.Activities.Business.VLookupX`

## Description

Finds data in a range or sheet using the VLOOKUP function. The activity can be used with an Excel file selected for a parent [Use Excel File](https://docs.uipath.com/activities/other/latest/productivity/excel-application-card) activity or with the Project Notebook.

## Configuring the activity

### Designer panel

* **Value to lookup** - Select **Plus** on the right side of the field, and then, from the menu, select what to look for using one of the available options:

  + Data from the Project Notebook, a parent Excel file or Outlook account. For example, select an Excel file, and then select **Indicate in Excel** to indicate a cell from the file, or select an email in Outlook and then select a field in the email that contains the value to search for.
  + **Use Saved Value** - Select a value that you previously saved for later use in the project.
  + **Text** - Enter the value using the Text Builder.
  + **Number** - Enter a numeric value.
  + **Ask when run** - Prompt for a value when the project is executed.
  + **Open in Advanced Editor** - Enter a VB expression.
* **In range** - Select **Plus** on the right side of the field, and then, from the menu, select the range where to search for the value. Select an Excel file, and then a sheet, table, or range, or select **Indicate in Excel** to indicate a range directly from the file. Alternatively, you can select **Custom Input** to enter a range, table name, or sheet name manually, or **Open in Advanced Editor** to enter a VB expression.
* **Column index** - Select **Plus** on the right side of the field and then, from the menu, select **Number** and enter the column number containing the value to return. Alternatively, you can use one of the available options in the menu to indicate the column index:

  + Select an Excel file and then a named cell that contains the column number, or select **Indicate in Excel** to indicate a cell in the column directly from the file.
  + **Use Saved Value** - Select a numeric value that you previously saved for later use in the project.
  + **Ask when run** - Prompt for a value when the project is executed.
  + **Open in Advanced Editor** - Enter a VB expression.
* **Exact match** - If selected, it indicates you want to return only exact matches. If not selected, approximate matches are returned. This option is selected by default.
* **Save to** - Select **Plus** on the right side of the field and then, from the menu, select where to save the result:

  + Select an Excel file and then a named cell, or select **Indicate in Excel** to indicate a cell from the file.
  + **Save for Later Use** - Save the result for later use in your project as input for another activity.
  + **Open in Advanced Editor** - Enter a VB expression.

### Properties panel

#### Common

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

#### Input

* See the options in the body of the activity.

#### Misc

* **Private** - If selected, the values of variables and arguments are no longer logged at Verbose level.

#### Output

* **Output to** - See **Save to** in the body of the activity.