Click or drag to resize
PicoXLSX

CellBasicFormulasVLookup(CellAddress, CellRange, Int32, Boolean) Method

Function to generate a Vlookup as Excel function

Namespace: PicoXLSX
Assembly: PicoXLSX (in PicoXLSX.dll) Version: 3.4.3+c820fb107cc06ae187946bad43db42d71f6faf1c
Syntax
C#
public static Cell VLookup(
	CellAddress address,
	CellRange range,
	int columnIndex,
	bool exactMatch
)

Parameters

address  CellAddress
Query address of a cell as string as source of the lookup.
range  CellRange
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

Cell
Prepared Cell object, ready to be added to a worksheet.
See Also