Top Description Constructors Methods
org.apache.poi.ss.formula.functions

public final Class Lookup

extends Var2or3ArgFunction
Class Inheritance
Imports
org.apache.poi.ss.formula.eval.EvaluationException, .OperandResolver, .ValueEval, org.apache.poi.ss.formula.functions.LookupUtils.ValueVector, org.apache.poi.ss.formula.TwoDEval
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.

Constructor Summary

AccessConstructor and Description
public
Lookup()

Method Summary

Modifier and TypeMethod and Description
private static LookupUtils.ValueVector
createVector(TwoDEval ae)

public ValueEval
evaluate(int srcRowIndex, int srcColumnIndex, ValueEval arg0, ValueEval arg1)

Implements org.apache.poi.ss.formula.functions.Function2Arg.evaluate.

see Function#evaluate(ValueEval[], int, int)

public ValueEval
evaluate(int srcRowIndex, int srcColumnIndex, ValueEval arg0, ValueEval arg1, ValueEval arg2)

Implements org.apache.poi.ss.formula.functions.Function3Arg.evaluate.

see Function#evaluate(ValueEval[], int, int)

Inherited from org.apache.poi.ss.formula.functions.Var2or3ArgFunction:
evaluate

Constructor Detail

Lookupback to summary
public Lookup()

Method Detail

createVectorback to summary
private static LookupUtils.ValueVector createVector(TwoDEval ae)
evaluateback to summary
public ValueEval evaluate(int srcRowIndex, int srcColumnIndex, ValueEval arg0, ValueEval arg1)

Implements org.apache.poi.ss.formula.functions.Function2Arg.evaluate.

Doc from org.apache.poi.ss.formula.functions.Function2Arg.evaluate.

see Function#evaluate(ValueEval[], int, int)

Annotations
@Override
evaluateback to summary
public ValueEval evaluate(int srcRowIndex, int srcColumnIndex, ValueEval arg0, ValueEval arg1, ValueEval arg2)

Implements org.apache.poi.ss.formula.functions.Function3Arg.evaluate.

Doc from org.apache.poi.ss.formula.functions.Function3Arg.evaluate.

see Function#evaluate(ValueEval[], int, int)

Annotations
@Override