BasicFormulasVLookup(Object, Worksheet, Range, Int32, Boolean) Method

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

Return Value

Reference