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
--------
	- :doc:`Add Workbook <exceladdworkbook>`
	- :doc:`Add Worksheet <exceladdworksheet>`
	- :doc:`Append Cell <excelappendcell>`
	- :doc:`Append Row <excelappendrow>`
	- :doc:`Close Workbook <excelcloseworkbook>`
	- :doc:`Copy Worksheet <excelcopysheet>`
	- :doc:`Delete Cell <exceldeletecell>`
	- :doc:`Delete Row <exceldeleterow>`
	- :doc:`Excel Create Datatable <excelcreatedataset>`
	- :doc:`Export to PDF <excelexporttopdf>`
	- :doc:`Get Cell <excelgetcell>`
	- :doc:`Get Cell Style <excelgetcellstyle>`
	- :doc:`Get Last Column Index <excelgetlastcolumn>`
	- :doc:`Get Last Row Index <excelgetlastrow>`
	- :doc:`Get Range <excelgetrange >`
	- :doc:`Get Range As Datatable <excelgetrangeasdt>`
	- :doc:`Get Worksheets <excelgetworksheets>`
	- :doc:`Go To Cell <excelgotocell>`
	- :doc:`Insert Cell <excelinsertcell>`
	- :doc:`Open Workbook <excelopenworkbook>`
	- :doc:`Remove Duplicate <excelremoveduplicate>`
	- :doc:`Run Macro <excelrunmacro>`
	- :doc:`Save Workbook <excelsave>`
	- :doc:`Save Workbook As <excelsaveas>`
	- :doc:`Set Range <excelsetcell>`
	- :doc:`Write Range <excelwriterange>`
	- :doc:`Write Row <excelwriterow>`