Examples of org.apache.poi.ss.formula.functions.Vlookup

Package org.apache.poi.ss.formula.functions

Examples of org.apache.poi.ss.formula.functions.Vlookup

org.apache.poi.ss.formula.functions.Vlookup
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

        retval[97] = NumericFunction.ATAN2;
        retval[98] = NumericFunction.ASIN;
        retval[99] = NumericFunction.ACOS;
        retval[ID.CHOOSE] = new Choose();
        retval[101] = new Hlookup();
        retval[102] = new Vlookup();


        retval[105] = LogicalFunction.ISREF;


        retval[109] = NumericFunction.LOG;

View Full Code Here

        retval[97] = NumericFunction.ATAN2;
        retval[98] = NumericFunction.ASIN;
        retval[99] = NumericFunction.ACOS;
        retval[ID.CHOOSE] = new Choose();
        retval[101] = new Hlookup();
        retval[102] = new Vlookup();


        retval[105] = LogicalFunction.ISREF;


        retval[109] = NumericFunction.LOG;

View Full Code Here

TOP

Related Classes of org.apache.poi.ss.formula.functions.Vlookup

org.apache.poi.ss.formula.eval.FunctionEval

org.apache.poi.ss.formula.eval.ValueEval

org.apache.poi.ss.formula.functions.LookupUtils.ValueVector

org.apache.poi.ss.formula.TwoDEval

All source code are property of their respective owners. Java is a trademark of Sun Microsystems, Inc and owned by ORACLE Inc. Contact coftware#gmail.com.