Lookup

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. Note: 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 Test is nonzero; returns Value2 if Test is zero.
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(N, Value0, [Value1, ...])	Returns the index of the Nth-largest Value from a variable-length list of values.
NthMinI(N, 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, Case0, Value0, [Case1, Value1, ...])	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. Switch Example A4 = Switch(A2,-1,2,"C",3,"B",A3,"A") If cell A2=2, the value returned in cell A4 would be C. If cell A2=3, the value returned in cell A4 would be B. If cell A2=5, the value returned to cell A4 would be the default, -1, because there is no Case in the formula that matches the FindCase.

Note: For function arguments that require a text string, you cannot supply the string directly through If, Switch, or Choose. For example, Len(If(...)) is invalid. To resolve this issue, place If, Switch, or Choose in a separate cell and create a reference to that cell.