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

PicoXLSX Library Documentation

CellBasicFormulasVLookup Method (Object, CellRange, Int32, Boolean)

Function to generate a Vlookup as Excel function

Namespace: PicoXLSX
Assembly: PicoXLSX (in PicoXLSX.dll) Version: 2.4.0.0 (2.4.0)

Syntax

public static Cell VLookup(
	Object number,
	CellRange range,
	int columnIndex,
	bool exactMatch
)

number: Type: SystemObject
Numeric value for the lookup. Valid types are int, long, float and double
range: Type: PicoXLSXCellRange
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 added to a worksheet