Spread WPF 14
GrapeCity.CalcEngine.Functions Namespace / CalcHLookupFunction Class
Members


In This Topic
    CalcHLookupFunction Class
    In This Topic
    Searches for a value in the top row of a table or an array of values, and then returns a value in the same column from a row you specify in the table or array.
    Object Model
    CalcHLookupFunction Class
    Syntax
    'Declaration
     
    Public Class CalcHLookupFunction 
       Inherits CalcBuiltinFunction
    'Usage
     
    Dim instance As CalcHLookupFunction
    public class CalcHLookupFunction : CalcBuiltinFunction 
    Remarks
    Use HLOOKUP when your comparison values are located in a row across the top of a table of data, and you want to look down a specified number of rows. Use VLOOKUP when your comparison values are located in a column to the left of the data you want to find.
    Inheritance Hierarchy

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

    See Also