Class Vlookup

  • All Implemented Interfaces:
    Function, Function3Arg, Function4Arg

    public final class Vlookup
    extends Object
    Implementation of the VLOOKUP() function.

    VLOOKUP finds a row in a lookup table by the first column value and returns the value from another column.
    Syntax:
    VLOOKUP(lookup_value, table_array, col_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.
    col_index_num a 1 based index specifying which column value of the lookup data will be returned.
    range_lookup If TRUE (default), VLOOKUP finds the largest value less than or equal to the lookup_value. If FALSE, only exact matches will be considered