CalcHLookupFunction Class

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

Syntax

Visual Basic
C#

'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

Reference

CalcHLookupFunction Members
GrapeCity.CalcEngine.Functions Namespace