CalcVLookupFunction Class

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

Syntax

Visual Basic
C#

'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

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

Reference

CalcVLookupFunction Members
GrapeCity.CalcEngine.Functions Namespace