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

Reference