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

A VLOOKUP reference function.

Namespace: DevExpress.Export.Xl

Assembly: DevExpress.Printing.v21.2.Core.dll


public static IXlFormulaParameter VLookup(
    XlVariantValue lookupValue,
    XlCellRange table,
    int columnIndex,
    bool rangeLookup


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.


Type Description

An IXlFormulaParameter object that is the function result.

See Also