beautypg.com

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

background image

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

“ADDRESS” (page 207)

The ADDRESS function constructs a cell address
string from separate row, column, and table
identifiers.

“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 specified index
value.

“COLUMN” (page 210)

The COLUMN function returns the column
number of the column containing a specified cell.

“COLUMNS” (page 211)

The COLUMNS function returns the number of
columns included in a specified 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 specified 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 specified
as a string.

9

Reference Functions