BasicFormulas.VLookup(Object, Worksheet, Range, Int32, Boolean) Method

Function to generate a Vlookup as Excel function

Namespace: NanoXLSX
Assembly: NanoXLSX (in NanoXLSX.dll) Version: 2.6.2+7f12a949130e0be1e987e553d2d08c083176cdca

Syntax

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

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

Cell
Prepared Cell object, ready to be added to a worksheet

Exceptions

Exception	Condition
FormatException	A format exception is thrown if the value or column index is invalid