Class Lookup

  • All Implemented Interfaces:
    Function, Function2Arg, Function3Arg

    public final class Lookup
    extends java.lang.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.