XlFunc.VLookup(IXlFormulaParameter, XlCellRange, Int32, Boolean) Method
In This Article
A VLOOKUP reference function
Namespace: DevExpress.Export.Xl
Assembly: DevExpress.Printing.v24.2.Core.dll
NuGet Package: DevExpress.Printing.Core
#Declaration
public static IXlFormulaParameter VLookup(
IXlFormulaParameter lookupValue,
XlCellRange table,
int columnIndex,
bool rangeLookup
)
#Parameters
Name | Type | Description |
---|---|---|
lookup |
IXl |
An IXl |
table | Xl |
A Xl |
column |
Int32 | An integer that is the index of a column in the range to search from which to retrieve a value. |
range |
Boolean | True means that if the function cannot find an exact match to the lookup value, it should use the closest match below the supplied value; false means that if the function cannot find an exact match, it should return an error. |
#Returns
Type | Description |
---|---|
IXl |
An IXl |
See Also