activities
latest
false
UiPath logo, featuring letters U and I in white

Productivity Activities

Last updated Apr 30, 2025

PREVIEW
VLookup Range

UiPath.MicrosoftOffice365.Activities.Excel.VLookupRangeConnections

Description

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

Scopes

This activity requires the following scopes:

  • Files.ReadWrite

OR

  • Files.ReadWrite.All

OR

  • Sites.ReadWrite.All

Project compatibility

Windows | Cross-platform

Configuration

  • Microsoft OneDrive & SharePoint - The connection for the Microsoft 365 account to use in the activity.
  • Workbook - The Drive Item of the Excel document.
  • Workbook sample - Select a file with the same ranges as the variable file. This field becomes visible when you select Use workbook template.
  • 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.
  • Value to lookup - The value to look up for. This property supports String variables and string formatted values.
  • 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, such as True, False. The default value is True.
  • Result - The value returned by VLOOKUP.
  • Description
  • Project compatibility
  • Configuration

Was this page helpful?

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