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

Namespace: DevExpress.Export.Xl

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

Declaration

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

Parameters

Name Type Description
lookupValue IXlFormulaParameter

An IXlFormulaParameter object that is the lookup value.

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