Skip to main content

XlFunc.VLookup(XlVariantValue, XlCellRange, Int32, Boolean) Method

A VLOOKUP reference function.

Namespace: DevExpress.Export.Xl

Assembly: DevExpress.Printing.v24.1.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.

See Also