Spread WPF Documentation
GrapeCity.CalcEngine.Functions Namespace / CalcVLookupFunction Class
Members


In This Topic
    CalcVLookupFunction Class
    In This Topic
    Searches for a value in the first column of a table array and returns a value in the same row from another column in the table array.
    Object Model
    CalcVLookupFunction Class
    Syntax
    'Declaration
     
    Public Class CalcVLookupFunction 
       Inherits CalcBuiltinFunction
    'Usage
     
    Dim instance As CalcVLookupFunction
    public class CalcVLookupFunction : CalcBuiltinFunction 
    Remarks
    The V in VLOOKUP stands for vertical. Use VLOOKUP instead of HLOOKUP when your comparison values are located in a column to the left of the data that you want to find.
    Inheritance Hierarchy

    System.Object
       GrapeCity.CalcEngine.Functions.CalcFunction
          GrapeCity.CalcEngine.Functions.CalcBuiltinFunction
             GrapeCity.CalcEngine.Functions.CalcVLookupFunction

    See Also