Lookup
Lookup functions return information about a particular spreadsheet cell or the data it holds.
Function |
Description |
||||
Choose (Index, Value0, [Value1, ...]) |
Returns the value of the indexed argument from a variable-length list.
|
||||
Column(Cell) |
Returns the column number of a spreadsheet Cell. Column A = 0.0 and Column Z = 25.0 |
||||
CountError(Cell1, [Cell2, ...]) |
Returns the number of errors in one or more cells or cell ranges.
|
||||
ErrFree(Cell or Cell Range) |
Converts #ERR to empty cells to suppress error propagation.
|
||||
If(Cond, Value1, Value2) |
Returns Value1 if Condition
is true (nonzero); |
||||
MaxI(Value0, [Value1, ...]) |
Returns the index of the maximum Value from a variable-length list of values.
|
||||
MinI(Value0, [Value1, ...]) |
Returns the index of the minimum Value from a variable-length list of values.
|
||||
NthMaxI(Int, Value0, [Value1, ...]) |
Returns the index of the Nth-largest Value from a variable-length list of values.
|
||||
NthMinI(Int, Value0, [Value1, ...]) |
Returns the index of the Nth-smallest Value from a variable-length list of values.
|
||||
Row(Cell) |
Returns the row number a spreadsheet Cell. |
||||
Switch (FindCase, Default, |
Returns the value corresponding to the first Case that matches the FindCase. If the indexed case is FALSE, then the specified Default value will be returned. If more than one Case in the formula matches the FindCase, then the value corresponding to the first matching Case will be returned.
Note: Switch statement supports string data type for case arguments. String comparisons are case-sensitive.
|