Class Hlookup

  • All Implemented Interfaces:
    Function, Function3Arg, Function4Arg

    public final class Hlookup
    extends Object
    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