Class Lookup

java.lang.Object
org.apache.poi.ss.formula.functions.Lookup
All Implemented Interfaces:
Function, Function2Arg, Function3Arg

public final class Lookup extends Object
Implementation of Excel function LOOKUP.

LOOKUP finds an index row in a lookup table by the first column value and returns the value from another column. Syntax:
VLOOKUP(lookup_value, lookup_vector, result_vector)

lookup_value The value to be found in the lookup vector.
lookup_vector</> An area reference for the lookup data.
result_vector Single row or single column area reference from which the result value is chosen.

Author:
Josh Micich