Lookup Range

Category

Excel Commands

Description

This command lookup text from a specified Excel range. Use this command when you want to lookup a value from a specified Excel range.

Parameters

Instance Name

Indicate the instance name for the selected workbook

Sheet Name

Indicate the name of the sheet within the Workbook to activate

Range

Enter the Range Location (ex. A1 or B2:G7)

Lookup Value

Enter text to lookup

Lookup By

Select lookup methodology

Variable

Assign result to variable

Returned Value

This command does not have returned value.

Example Usage

Example Location:

BYpass\Examples\Excel Commands\Lookup Range\Lookup Range.xml

See Also

• Add Workbook

• Add Worksheet

• Append Cell

• Append Row

• Close Workbook

• Copy Worksheet

• Delete Cell

• Delete Row

• Excel Create Datatable

• Export to PDF

• Get Cell

• Get Cell Style

• Get Last Column Index

• Get Last Row Index

• Get Range

• Get Range As Datatable

• Get Worksheets

• Go To Cell

• Insert Cell

• Open Workbook

• Remove Duplicate

• Run Macro

• Save Workbook

• Save Workbook As

• Set Range

• Write Range

• Write Row