Apple iWork '09 - Manual (Page 219)

Chapter 9 Reference Functions 219
Examples
Given the following table:
=MATCH(40, A1:A5) returns 4.
=MATCH(40, E1:E5) returns 1.
=MATCH(35, E1:E5, 1) returns 3 (30 is the largest value less than or equal to 35).
=MATCH(35, E1:E5, -1) returns 1 (40 is the smallest value greater than or equal to 35).
=MATCH(35, E1:E5, 0) displays an error (no exact match can be found).
=MATCH(”lorem”, C1:C5) returns 1 (“lorem” appears in the first cell of the range).
=MATCH(”*x”,C1:C5,0) returns 3 (“lorex”, which ends with an “x”, appears in the third cell of the range).
Related Topics
For related functions and additional information, see:
“LOOKUP” on page 217
“Specifying Conditions and Using Wildcards” on page 360
“Listing of Reference Functions” on page 206
“Value Types” on page 36
“The Elements of Formulas” on page 15
“Using the Keyboard and Mouse to Create and Edit Formulas” on page 26
“Pasting from Examples in Help” on page 41
OFFSET
The OFFSET function returns a range of cells that is the specified number of rows and
columns away from the specified base cell.
OFFSET(base, row-offset, column-offset, rows, columns)
 base: The address of the cell from which the offsets are measured. base is a
reference value.
 row-offset: The number of rows from the base cell to the target cell. row-offset is a
number value. 0 means the target cell is in the same row as the base cell. A negative
number means the target is in a row above the base.