XlFunc.VLookup(IXlFormulaParameter, 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

C#

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

VB.NET

Public Shared Function VLookup(
    lookupValue As IXlFormulaParameter,
    table As XlCellRange,
    columnIndex As Integer,
    rangeLookup As Boolean
) As IXlFormulaParameter

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.