CellBasicFormulasVLookup(Object, CellRange, Int32, Boolean) Method

public static Cell VLookup(
	Object number,
	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.

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