Activities
latest
false
Productivity Activities
Last updated Jul 9, 2024

Lookup

UiPath.Excel.Activities.Business.LookupX

Finds data in a range or sheet using the LOOKUP function. Use this activity to search in a row or column and find a value from the same position in a second row or column. This activity can be used with an Excel file selected for a parent Use Excel File activity or with the Project Notebook.

Configuring the Activity

In the Body of the Activity
  • Value to lookup - The value to search for.

  • Range - The range where to search for the value. Use a single row or column for the vector form of LOOKUP, or a range with multiple rows and columns for the array form (search in the first row or column and find in the last row or column).
  • Source of results - (Optional) A single row or column from which to return the value. Use this for the vector form.
  • Result - Where to save the returned value.

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

  • Result - See Result in the body of the activity.
  • Configuring the Activity

Was this page helpful?

Get The Help You Need
Learning RPA - Automation Courses
UiPath Community Forum
Uipath Logo White
Trust and Security
© 2005-2024 UiPath. All rights reserved.