Cell.BasicFormulas.VLookup Method (Cell.Address, Cell.Range, Int32, Boolean)

NanoXLSX Library Documentation

CellBasicFormulasVLookup Method (CellAddress, CellRange, Int32, Boolean)

Function to generate a Vlookup as Excel function

Namespace: NanoXLSX
Assembly: NanoXLSX (in NanoXLSX.dll) Version: 1.2.3.0 (1.2.3)

Syntax

public static Cell VLookup(
	CellAddress address,
	CellRange range,
	int columnIndex,
	bool exactMatch
)

address: Type: NanoXLSXCellAddress
Query address of a cell as string as source of the lookup
range: Type: NanoXLSXCellRange
Matrix of the lookup
columnIndex: Type: SystemInt32
Column index of the target column (1 based)
exactMatch: Type: SystemBoolean
If true, an exact match is applied to the lookup

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