VLookup

Calls Excel VLookup function for given Excel file with desired options.

Input

• Value to Lookup: The value to be searched
  • Type: System.String
  • Required
• Range: The range where the search will be conducted
  • Type: System.String
• Column Index: The information about which column to search in
  • Type: System.Int32
• Exact Match: If an exact match is desired, it should be checked.
  • Type: System.Boolean
  • Required

Output

• Founded Value: Information about the found value
  • Type: System.Object

Details

• This activity can only be used within the Use Excel File activity. Excel application must be installed on the machine where the process will run.