BasicFormulasGetVLookup Method

private static Cell GetVLookup(
	Worksheet queryTarget,
	Address address,
	Object number,
	Worksheet rangeTarget,
	Range 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  Address

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  Range

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