Class
VLookup

Searches the leftmost column of a table for a value and returns a match from a specified column in the same row, supporting both exact and approximate matching.

Definition

Namespace:Telerik.Windows.Documents.Spreadsheet.Expressions.Functions

Assembly:Telerik.Windows.Documents.Spreadsheet.dll

Syntax:

cs-api-definition

public class VLookup : LookupFunctionBase

Inheritance: objectFunctionBaseFunctionWithArgumentsLookupFunctionBaseVLookup

Inherited Members LookupFunctionBase.EvaluateOverride(FunctionEvaluationContext<object>)FunctionWithArguments.EvaluateOverride(FunctionEvaluationContext<RadExpression>)FunctionBase.Evaluate(FunctionEvaluationContext<RadExpression>)FunctionBase.IsArgumentNumberValid(int)FunctionBase.ArgumentConversionRules

Constructors

VLookup()

Initializes a new VLOOKUP function instance for vertical lookup operations in table data.

Declaration

cs-api-definition

public VLookup()

Fields

FunctionName

The name of the function.

Declaration

cs-api-definition

public static readonly string FunctionName

Field Value

string

Properties

FunctionInfo

Gets the metadata describing this function's category, arguments, and behavior.

Declaration

cs-api-definition

public override FunctionInfo FunctionInfo { get; }

Property Value

FunctionInfo

The function info as FunctionInfo.

Overrides FunctionBase.FunctionInfo

Name

Gets the function name "VLOOKUP".

Declaration

cs-api-definition

public override string Name { get; }

Property Value

string

The name as String.

Overrides FunctionBase.Name

ClassVLookup

Class
VLookup