CellBasicFormulasGetVLookup Method

private static Cell GetVLookup(
	Worksheet queryTarget,
	CellAddress address,
	Object number,
	Worksheet rangeTarget,
	CellRange range,
	int columnIndex,
	bool exactMatch,
	bool numericLookup
)

Parameters

queryTarget  Worksheet

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

address  CellAddress

In case of a reference lookup, query address of a cell as string.

number  Object

In case of a numeric lookup, number for 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.

numericLookup  Boolean

If true, the lookup is a numeric lookup, otherwise a reference lookup.

Return Value

Reference