Spread WinRT Documentation
GrapeCity.CalcEngine.Functions Namespace / CalcMatchFunction Class / Evaluate Method / Evaluate(Object[]) Method

The args contains 2 - 3 items: lookup_value, lookup_array, [match_type].

Lookup_value is the value you use to find the value you want in a table.

Lookup_array is a contiguous range of cells containing possible lookup values. Lookup_array must be an array or an array reference.

[Match_type] is the number -1, 0, or 1. Match_type specifies how to matches lookup_value with values in lookup_array.



In This Topic
    Evaluate(Object[]) Method
    In This Topic
    Returns the relative position of an item in an array that matches a specified value in a specified order.
    Syntax
    'Declaration
     
    Public Overloads Overrides Function Evaluate( _
       ByVal args() As Object _
    ) As Object
    'Usage
     
    Dim instance As CalcMatchFunction
    Dim args() As Object
    Dim value As Object
     
    value = instance.Evaluate(args)
    public override object Evaluate( 
       object[] args
    )

    Parameters

    args

    The args contains 2 - 3 items: lookup_value, lookup_array, [match_type].

    Lookup_value is the value you use to find the value you want in a table.

    Lookup_array is a contiguous range of cells containing possible lookup values. Lookup_array must be an array or an array reference.

    [Match_type] is the number -1, 0, or 1. Match_type specifies how to matches lookup_value with values in lookup_array.

    Return Value

    A System.Int32 value that indicates the evaluate result.
    See Also