Chapter 9: reference functions, Listing of reference functions, Chapter 9: reference functions – Apple iWork '09 User Manual
Page 206: 206 listing of reference functions, Reference functions

206
The reference functions help you find data within tables and
retrieve data from cells.
Listing of Reference Functions
iWork provides these reference functions for use with tables.
Function
Description
The ADDRESS function constructs a cell address
string from separate row, column, and table
identifiers.
The AREAS function returns the number of
ranges the function references.
The CHOOSE function returns a value from a
collection of values based on a specified index
value.
The COLUMN function returns the column
number of the column containing a specified cell.
The COLUMNS function returns the number of
columns included in a specified range of cells.
The HLOOKUP function returns a value from a
range of rows by using the top row of values to
pick a column and a row number to pick a row
within that column.
“HYPERLINK” (page 213)
The HYPERLINK function creates a clickable link
that opens a webpage or new email message.
The INDEX function returns the value in the cell
located at the intersection of the specified row
and column within a range of cells.
The INDIRECT function returns the contents of a
cell or range referenced by an address specified
as a string.
9
Reference Functions