Term
| CHOOSE(k, value 1, value 2 ... value n) |
|
Definition
| Find the kth value in a number of strings specified by the arguments. |
|
|
Term
HLOOKUP(lookup value, cell range, row number, Boolean)
If the Boolean argument is TRUE or omitted, it will find the largest value smaller than the lookup value when the lookup value cannot be found. If the Boolean argument is FALSE and the lookup value cannot be found, the will return the #N/A error. |
|
Definition
| Search the first row of the cell range for a lookup value, then find the corresponding value in a certain row in the cell range.. |
|
|
Term
VLOOKUP(lookup value, cell range, column number, Boolean)
If the Boolean argument is TRUE or omitted, it will find the largest value smaller than the lookup value when the lookup value cannot be found. If the Boolean argument is FALSE and the lookup value cannot be found, the will return the #N/A error. |
|
Definition
| Search the first column of the cell range for a lookup value, then find the corresponding value in a certain column in the cell range. |
|
|
Term
| LOOKUP(lookup value, cell range 1, cell range 2) |
|
Definition
| Search for the lookup value in cell range 1 and return the corresponding value in cell range 2. |
|
|
Term
|
Definition
| Return a serial number representing a particular date. |
|
|
Term
NOW()
This function updates. |
|
Definition
| Return the system time and date. |
|
|
