 | BasicFormulasVLookup(Address, Range, Int32, Boolean) Method |
Function to generate a Vlookup as Excel function
Namespace: NanoXLSXAssembly: NanoXLSX (in NanoXLSX.dll) Version: 2.6.7+b0ed5f8a99a50b9e6528224889fbd7f23c30b364
Syntaxpublic 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
CellPrepared Cell object, ready to be added to a worksheet
Exceptions| Exception | Condition |
|---|
| FormatException | A format exception is thrown if the column index is invalid |
See Also