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
| 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 rowIndex)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 | |
| Hlookup | back to summary |
|---|---|
| public Hlookup() | |
| 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 arg0, ValueEval arg1, ValueEval arg2, ValueEval arg3) Implements org. Doc from org. see
| |