Lookup Range
This activity searches for a specific value within a range in the specified sheet and returns the corresponding cell value. It functions within the “Excel Scope” activity.
Properties
INPUT
SheetName: *Specify the “SheetName” from where the value needs to be found, and it accepts values in the “String” datatype.
Range: *Specify the range of values to be read from the specified sheet and it accepts values in the “String” datatype.
Value: *Specify the input “value” to be found within the defined range, and it accepts values in “String” datatype.
MISC
DisplayName: Displays the name of the activity. The activity name can be customized, which aids in troubleshooting.
SkipOnError: Specify the “Boolean” value as “True” or “False.”
True: Continue executing the workflow regardless of any errors thrown.
False: Halt the workflow if it encounters any errors.
None: If the option is left blank, the activity will, by default, behave as if “False” were chosen.
Version: It indicates the version of the feature being used.
OUTPUT
Result: This parameter allows you to view the execution status of the activity and returns a value in “Boolean.”
True: Indicates that the activity has been executed successfully without any errors.
False: Indicates that the activity has been unsuccessful due to an unexpected error being thrown.
CellValue: This parameter allows you to view the cell reference value where the specified text is found and returns the value in “String” datatype.
* Represents mandatory fields to execute the workflow.