Apple numbers User Manual

    Dictionary of Functions 

 

  

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.

  

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.

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.

LOWER("UPPER") returns "upper".

LOWER("Lower") returns "lower".

LOWER("MiXeD") returns "mixed".