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.5+3a069966d2787c42b695e5043a5e083b247634e3
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