BasicFormulas.VLookup(Worksheet, Address, 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(
	Worksheet queryTarget,
	Address address,
	Worksheet rangeTarget,
	Range range,
	int columnIndex,
	bool exactMatch
)

queryTarget Worksheet: Target worksheet of the query argument. Can be null if on the same worksheet
address Address: Query address of a cell as string as source of 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

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

Exceptions

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