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.2+f55916d49ef2baa43fc7dc8f5c7d751a77c50baf
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