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

PicoXLSX

previous page next page
PicoXLSX

CellBasicFormulasVLookup Method (Worksheet, CellAddress, Worksheet, 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
C#
Copy
public static Cell VLookup(
	Worksheet queryTarget,
	CellAddress address,
	Worksheet rangeTarget,
	CellRange range,
	int columnIndex,
	bool exactMatch
)

Parameters

queryTarget
Type: PicoXLSXWorksheet
Target worksheet of the query argument. Can be null if on the same worksheet
address
Type: PicoXLSXCellAddress
Query address of a cell as string as source of the lookup
rangeTarget
Type: PicoXLSXWorksheet
Target worksheet of the matrix. Can be null if on the same worksheet
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

Return Value

Type: Cell
Prepared Cell object, ready to added to a worksheet
See Also
previous page start next page