CellBasicFormulasVLookup(Worksheet, CellAddress, Worksheet, CellRange, Int32, Boolean) Method

public static Cell VLookup(
	Worksheet queryTarget,
	CellAddress address,
	Worksheet rangeTarget,
	CellRange range,
	int columnIndex,
	bool exactMatch
)

Parameters

queryTarget  Worksheet

Target worksheet of the query argument. Can be null if on the same worksheet.

address  CellAddress

Query address of a cell as string as source of the lookup.

rangeTarget  Worksheet

Target worksheet of the matrix. Can be null if on the same worksheet.

range  CellRange

Matrix of the lookup.

columnIndex  Int32

Column index of the target column within the range (1 based).

exactMatch  Boolean

If true, an exact match is applied to the lookup.

Return Value

Reference