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
'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
Requirements
Target Platforms: Windows 7, Windows 8 Desktop, Windows Vista SP1 or later, Windows Server 2000, Windows 2000 Professional, Windows XP Professional, Windows NT 4.0 Workstation, SP6, Windows NT 4.0 Server, SP6
See Also