org.apache.poi.hssf.record.formula.functions
Class Hlookup

java.lang.Object
  extended by org.apache.poi.hssf.record.formula.functions.Hlookup
All Implemented Interfaces:
Function

public final class Hlookup
extends java.lang.Object
implements Function

Implementation of the HLOOKUP() function.

HLOOKUP finds a column in a lookup table by the first row value and returns the value from another row.
Syntax:
HLOOKUP(lookup_value, table_array, row_index_num, range_lookup)

lookup_value The value to be found in the first column of the table array.
table_array An area reference for the lookup data.
row_index_num a 1 based index specifying which row value of the lookup data will be returned.
range_lookup If TRUE (default), HLOOKUP finds the largest value less than or equal to the lookup_value. If FALSE, only exact matches will be considered

Author:
Josh Micich

Constructor Summary
Hlookup()
           
 
Method Summary
 Eval evaluate(Eval[] args, int srcCellRow, short srcCellCol)
           
 
Methods inherited from class java.lang.Object
clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait
 

Constructor Detail

Hlookup

public Hlookup()
Method Detail

evaluate

public Eval evaluate(Eval[] args,
                     int srcCellRow,
                     short srcCellCol)
Specified by:
evaluate in interface Function


Copyright 2008 The Apache Software Foundation or its licensors, as applicable.