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.