private static Cell GetVLookup(
	Worksheet queryTarget,
	CellAddress address,
	Object number,
	Worksheet rangeTarget,
	CellRange range,
	int columnIndex,
	bool exactMatch,
	bool numericLookup
)

Parameters

queryTarget

Type: PicoXLSXWorksheet
Target worksheet of the query argument. Can be null if on the same worksheet

address

Type: PicoXLSXCellAddress
In case of a reference lookup, query address of a cell as string

number

Type: SystemObject
In case of a numeric lookup, number for 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

numericLookup

Type: SystemBoolean
If true, the lookup is a numeric lookup, otherwise a reference lookup

Return Value

Reference