BasicFormulasVLookup(Worksheet, Address, Worksheet, Range, Int32, Boolean) Method

public static Cell VLookup(
	Worksheet queryTarget,
	Address address,
	Worksheet rangeTarget,
	Range range,
	int columnIndex,
	bool exactMatch
)

Parameters

queryTarget  Worksheet

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

address  Address

Query address of a cell as string as source of the lookup

rangeTarget  Worksheet

Target worksheet of the matrix. Can be null if on the same worksheet

range  Range

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

Reference