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

public static Cell VLookup(
	Object number,
	Worksheet rangeTarget,
	CellRange range,
	int columnIndex,
	bool exactMatch
)

Parameters

number  Object

Numeric value for the lookup.Valid types are int, uint, long, ulong, float, double, byte, sbyte, decimal, short and ushort.

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