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.

Inheritance
System.Object
FunctionBase
FunctionWithArguments
LookupFunctionBase
VLookup
Inherited Members
System.Object.ToString()
System.Object.Equals(System.Object)
System.Object.Equals(System.Object, System.Object)
System.Object.ReferenceEquals(System.Object, System.Object)
System.Object.GetHashCode()
System.Object.GetType()
System.Object.MemberwiseClone()
Namespace: Telerik.Windows.Documents.Spreadsheet.Expressions.Functions
Assembly: Telerik.Windows.Documents.Spreadsheet.dll

Syntax

public class VLookup : LookupFunctionBase

Constructors

VLookup()

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

Declaration
public VLookup()

Fields

FunctionName

The name of the function.

Declaration
public static readonly string FunctionName
Field Value
System.String

Properties

FunctionInfo

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

Declaration
public override FunctionInfo FunctionInfo { get; }
Property Value
FunctionInfo

The function info as FunctionInfo.
Overrides

Name

Gets the function name "VLOOKUP".

Declaration
public override string Name { get; }
Property Value
System.String

The name as String.
Overrides