Apple iWork '09 - Manual (Page 207)

Chapter 9 Reference Functions 207
Function Description
“LOOKUP” (page 217) The LOOKUP function finds a match for a given
search value in one range, and then returns the
value in the cell with the same relative position in
a second range.
“MATCH” (page 218) The MATCH function returns the position of a
value within a range.
“OFFSET” (page 219) The OFFSET function returns a range of cells that
is the specified number of rows and columns
away from the specified base cell.
“ROW” (page 221) The ROW function returns the row number of the
row containing a specified cell.
“ROWS” (page 221) The ROWS function returns the number of rows
included in a specified range of cells.
“TRANSPOSE” (page 222) The transpose function returns a vertical range of
cells as a horizontal range of cells, or vice versa.
“VLOOKUP” (page 223) The VLOOKUP function returns a value from a
range of columns by using the left column of
values to pick a row and a column number to
pick a column in that row.
ADDRESS
The ADDRESS function constructs a cell address string from separate row, column, and
table identifiers.
ADDRESS(row, column, addr-type, addr-style, table)
 row: The row number of the address. row is a number value that must be in the
range 1 to 65,535.
 column: The column number of the address. column is a number value that must
be in the range 1 to 256.
 addr-type: An optional value specifying whether the row and column numbers are
relative or absolute.
all absolute (1 or omitted): Row and column references are absolute.
row absolute, column relative (2): Row references are absolute and column
references are relative.
row relative, column absolute (3): Row references are relative and column
references are absolute.
all relative (4): Row and column references are relative.
 addr-style: An optional value specifying the address style.