Apple Numbers '08 - Manual (Page 246)

246 Chapter 12 Dictionary of Functions
LOWER
The LOWER function converts uppercase characters in text to lowercase.
LOWER(text)
 text: A text expression or reference to a cell containing a text expression.
MATCH
The MATCH function finds the position of a value within a row or column range. Cell
numbering starts with 1 at the top or left cell for vertical and horizontal ranges,
respectively. Searches are performed top-to-bottom and left-to-right.
MATCH(search-value, cell-range, [method])
 search-value: The text or numeric expression you want to find.
 cell-range: A range of cells within a single row or column.
 method: Optional; specifies how value matching is performed:
1 (or omitted) matches the cell containing the largest value less than or equal to
search-value.
0 matches the first cell with a value that matches search-value exactly.
–1 matches the cell containing the smallest value greater than or equal to search-
value.
Examples
Given the following table:
LOOKUP("C", A1:F1, A2:F2) returns 30.
LOOKUP(40, A2:F2, A1:F1) returns D.
LOOKUP("B", A1:C1, D2:F2) returns 50.
Examples
LOWER("UPPER") returns "upper".
LOWER("Lower") returns "lower".
LOWER("MiXeD") returns "mixed".