Activities
latest
false
VLookup Range - Other latest
logo
Productivity Activities
Last updated 2023年11月16日

VLookup Range

UiPath.MicrosoftOffice365.Activities.Excel.VLookupRange

Description

Uses the Microsoft Graph Use workbook functions API to find a value in a range using the VLOOKUP function.

Project compatibility

Windows - Legacy | Windows

Configuration

Properties

Common

  • DisplayName - The display name of the activity. This property supports String variables and string formatted values.

Input

  • Column Index - The column index in the range containing the value to return. This field supports only integer and Int32 variables.
  • Exact Match - Indicates whether to return exact matches or approximate matches. This field only supports Boolean values (True, False). The default value is True.
  • Range - The range to search for the lookup value. If not set, it will search in the entire sheet. This property supports String variables and string formatted values.

    Note: For the activity to work correctly, the lookup value should always be in the first column in the range.
  • Sheet Name - The name of the sheet. This property supports String variables and string formatted values.
  • Value to Lookup - The value to look up for. This property supports String variables and string formatted values.
  • Workbook - The Drive Item of the Excel document. Use the Find Files And Folders activity to retrieve this Drive Item. This field supports only DriveItem variables.

Misc

  • Private - If selected, the values of variables and arguments are no longer logged at Verbose level. This field supports Boolean values.

Output

  • Result - The value returned by VLOOKUP.
  • Description
  • Project compatibility
  • Configuration
logo
Get The Help You Need
logo
Learning RPA - Automation Courses
logo
UiPath Community Forum
Uipath Logo White
Trust and Security
© 2005-2023 UiPath. All rights reserved.