Calc Guide

Syntax Description
function returns a logical or numerical value.
Reference contains the address of the cell in
which the error occurs.
HLOOKUP(search_criteria;
array; index; sorted)
Searches for a value and reference to the
cells below the selected area. This function
verifies if the first row of an array contains a
certain value. The function returns the value
in a row of the array, named in the index, in
the same column. The search supports
regular expressions.
HYPERLINK(URL) or
HYPERLINK(URL; cell_text)
When a cell that contains the HYPERLINK
function is clicked, the hyperlink opens. URL
specifies the link target. The optional
cell_text argument is the text displayed in
the cell. If the cell_text parameter is not
specified, the URL is displayed.
INDEX(reference; row;
column; range)
Returns the content of a cell, specified by
row and column number or an optional range
name. Reference is a cell reference, entered
either directly or by specifying a range name.
If the reference consists of multiple ranges,
the reference or range name must be
enclosed in parentheses. Row (optional) is
the row number of the reference range, for
which to return a value. Column (optional) is
the column number of the reference range,
for which to return a value. Range (optional)
is the index of the subrange if referring to a
multiple range.
INDIRECT(reference)
Returns the reference specified by a text
string. This function can also be used to
return the area of a corresponding string.
Reference is a reference to a cell or an area
(in text form) for which to return the
contents.
LOOKUP(search_criterion;
search_vector;
result_vector)
Returns the contents of a cell either from a
one-row or one-column range or from an
array. Optionally, the assigned value (of the
same index) is returned in a different column
and row. As opposed to VLOOKUP and
HLOOKUP, search and result vectors may be
at different positions; they do not have to be
adjacent. Additionally, the search vector for
the LOOKUP must be sorted, otherwise the
472 OpenOffice.org 3.x Calc Guide