Skip to main content

Lookup Range

Searches in a specified range for the coordinates of a cell with a certain value and returns them as String variables

Input​

  • Range: The range where you want to perform the search
    • Type: System.String
  • Sheet Name: The name of the sheet in the workbook where the change must be made.
    • Type: System.String
  • Value to Lookup: The value that you want to search for.
    • Type: System.String
    • Required
  • Exact Match: If an exact match is desired, it should be checked.
    • Type: System.Boolean
    • Required

Output​

  • Result: The cell where the specified value is found
    • Type: System.String
    • Required

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.