Formulas and Functions

206
The reference functions help you nd data within tables and
retrieve data from cells.
Listing of Reference Functions
iWork provides these reference functions for use with tables.
Function Description
“ADDRESS” (page 207) The ADDRESS function constructs a cell address
string from separate row, column, and table
identiers.
“AREAS” (page 209) The AREAS function returns the number of
ranges the function references.
“CHOOSE” (page 209) The CHOOSE function returns a value from a
collection of values based on a specied index
value.
“COLUMN” (page 210) The COLUMN function returns the column
number of the column containing a specied cell.
“COLUMNS” (page 2 11 ) The COLUMNS function returns the number of
columns included in a specied range of cells.
“HLOOKUP” (page 211 ) 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.
“INDEX” (page 214) The INDEX function returns the value in the cell
located at the intersection of the specied row
and column within a range of cells.
“INDIRECT” (page 216) The INDIRECT function returns the contents of a
cell or range referenced by an address specied
as a string.
9
Reference Functions