Apple numbers 用户手册
Chapter 12
Dictionary of Functions
199
Reference Functions
Reference functions help you find data in tables and retrieve data from cells.
Numbers provides these reference functions.
Function
Description
Constructs a cell address string from separate row, column, and
table identifiers.
table identifiers.
Counts how many cell ranges are in the argument.
Uses an index value to retrieve a particular value from a set of
values.
values.
Returns the column number of a cell or, if no cell is specified, the
column number of the cell that contains the COLUMN function.
column number of the cell that contains the COLUMN function.
Counts how many columns are in a range of cells.
Retrieves a value from a range of rows by using the top row values
to pick a column and a row number to pick a row in that column.
to pick a column and a row number to pick a row in that column.
Creates a clickable link that opens a webpage or new email
message window.
message window.
Retrieves the value found in, or a reference to, the cell at the
intersection of a specified row and column within a range of cells.
intersection of a specified row and column within a range of cells.
Retrieves the value at, or a reference to, a specified address.
Retrieves a value from one range of cells based on a search match
in a second range.
in a second range.
Finds the position of a search value within a range.
Retrieves one or more values a given number of rows and columns
from a specified base cell.
from a specified base cell.
Returns the row number of a cell or, if no cell is specified, the row
that contains the ROW function.
that contains the ROW function.
Counts how many rows are in a range of cells.
Retrieves 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.
of values to pick a row and a column number to pick a column in
that row.