XlFunc.VLookup(XlVariantValue, XlCellRange, Int32, Boolean) Method
A VLOOKUP reference function.
Namespace: DevExpress.Export.Xl
Assembly: DevExpress.Printing.v23.2.Core.dll
NuGet Package: DevExpress.Printing.Core
Declaration
public static IXlFormulaParameter VLookup(
XlVariantValue lookupValue,
XlCellRange table,
int columnIndex,
bool rangeLookup
)Parameters
| Name | Type | Description |
|---|---|---|
| lookupValue | XlVariantValue | An XlVariantValue object that is the lookup value. However, a value of any standard type can be supplied because the XlVariantValue class implements multiple implicit constructors. |
| table | XlCellRange | A XlCellRange object that is the reference to the range to search. |
| columnIndex | Int32 | An integer that is the index of a column in the range to search from which to retrieve a value. |
| rangeLookup | 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 |
|---|---|
| IXlFormulaParameter | An IXlFormulaParameter object that is the function result. |