Click or drag to resize
NanoXLSX

BasicFormulasVLookup(Address, Range, Int32, Boolean) Method

Function to generate a Vlookup as Excel function

Namespace: NanoXLSX
Assembly: NanoXLSX (in NanoXLSX.dll) Version: 2.6.3+98f265239ae8df4639650ecd7029244cc5e52dfc
Syntax
C#
public static Cell VLookup(
	Address address,
	Range range,
	int columnIndex,
	bool exactMatch
)

Parameters

address  Address
Query address of a cell as string as source of the lookup
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

Cell
Prepared Cell object, ready to be added to a worksheet
Exceptions
ExceptionCondition
FormatExceptionA format exception is thrown if the column index is invalid
See Also