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
| Modifier and Type | Field and Description |
|---|---|
| private static final ValueEval |
| Access | Constructor and Description |
|---|---|
| public |
| Modifier and Type | Method and Description |
|---|---|
| private LookupUtils. | createResultColumnVector(TwoDEval tableArray, int
assumed to be non-negative colIndex)Returns one column from an |
| public ValueEval | evaluate(int srcRowIndex, int srcColumnIndex, ValueEval arg0, ValueEval arg1, ValueEval arg2)
Implements org. |
| public ValueEval |
| DEFAULT_ARG3 | back to summary |
|---|---|
| private static final ValueEval DEFAULT_ARG3 | |
| Vlookup | back to summary |
|---|---|
| public Vlookup() | |
| createResultColumnVector | back to summary |
|---|---|
| private LookupUtils. Returns one column from an
| |
| evaluate | back to summary |
|---|---|
| public ValueEval evaluate(int srcRowIndex, int srcColumnIndex, ValueEval arg0, ValueEval arg1, ValueEval arg2) Implements org. Doc from org. see
| |
| evaluate | back to summary |
|---|---|
| public ValueEval evaluate(int srcRowIndex, int srcColumnIndex, ValueEval lookup_value, ValueEval table_array, ValueEval col_index, ValueEval range_lookup) Implements org. Doc from org. see
| |