Skip to main content
Version: Current

LookUp Range

Description​

The LookUp Range activity searches a worksheet for cells that contain a specified value or formula and returns the addresses of all matching cells.

This activity can search an entire worksheet or a specific range and supports both case-sensitive and exact-match searches.

Common Capabilities​

Process Data Support​

info

This activity supports dynamic configuration using variables from the Process Data drawer.

You can bind values from Model Data, Form Data, System Data, Enterprise Variables, and Activity Outputs.

Learn more → Using Process Data

Design-Time Configuration​

Workbook Configuration​

This activity requires an Excel workbook.

Learn more → Excel Workbook Configuration

Worksheet Selection​

This activity operates on a worksheet within the workbook.

Learn more → Excel Worksheet Selection

Search String​

Value or formula to search for.

Examples:

  • Customer
  • Invoice-1001
  • Total
  • =SUM(A1:A10)

Range​

Optional range used to limit the search area.

Learn more → Worksheet Data Selection

Examples:

  • A1:D100
  • A:A
  • B2:F50

When not specified, the entire worksheet is searched.

Match Case​

Determines whether character casing is considered during the search.

When enabled:

  • Customer does not match customer
  • ABC does not match abc

Default value is False.

Match Entire Cell Contents​

Determines whether the entire cell value must match the search string.

When enabled:

  • Searching for Customer matches a cell containing exactly Customer
  • Searching for Customer does not match Customer Name

When disabled:

  • Partial matches are allowed

Default value is False.

Behavior​

The activity searches the specified range, or the entire worksheet when no range is provided, and returns the addresses of all matching cells.

Matching behavior is controlled by the Match Case and Match Entire Cell Contents options.

Outputs​

Cell Addresses​

Returns a collection of cell addresses that match the search criteria.

Example:

A2
A15
C8
D20

If no matches are found, an empty collection is returned.

Wait All Incoming​

Execution Control

Controls how this activity behaves when multiple incoming execution paths converge.

Determines whether the activity executes when any incoming path completes, or only after all relevant paths have completed.

Learn more → Execution Control

On Error​

Error Handling Strategy

Defines how the workflow behaves if this activity encounters a runtime error.

Supported strategies include Fault, Continue, Suspend, and Retry.

Learn more → Error Handling