New to Telerik Document Processing? Start a free 30-day trial

VLookup

Class

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:

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.

public VLookup()

Fields

FunctionName

string

The name of the function.

public static readonly string FunctionName

Properties

FunctionInfo

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

public override FunctionInfo FunctionInfo { get; }

Property Value:

The function info as FunctionInfo.

Overrides: FunctionBase.FunctionInfo

Name

string

Gets the function name "VLOOKUP".

public override string Name { get; }

Property Value:

The name as String.

Overrides: FunctionBase.Name