Calc Guide

Syntax Description
search will not return any usable results. The
search supports regular expressions.
Search_criterion is the value to be searched
for; entered either directly or as a reference.
Search_vector is the single-row or single-
column area to be searched. Result_vector
is another single-row or single-column range
from which the result of the function is
taken. The result is the cell of the result
vector with the same index as the instance
found in the search vector.
MATCH(search_criterion;
lookup_array; type)
Returns the relative position of an item in an
array that matches a specified value. The
function returns the position of the value
found in the lookup_array as a number.
Search_criterion is the value which is to be
searched for in the single-row or single-
column array. Lookup_array is the reference
searched. A lookup array can be a single row
or column, or part of a single row or column.
Type may take the values 1, 0, or –1. This
corresponds to the same function in
Microsoft Excel. The search supports regular
expressions
OFFSET(reference; rows;
columns; height; width)
Returns the value of a cell offset by a certain
number of rows and columns from a given
reference point. Reference is the cell from
which the function searches for the new
reference. Rows is the number of cells by
which the reference was corrected up
(negative value) or down. Columns is the
number of columns by which the reference
was corrected to the left (negative value) or
to the right. Height is the optional vertical
height for an area that starts at the new
reference position. Width is the optional
horizontal width for an area that starts at the
new reference position.
ROW(reference) Returns the row number of a cell reference.
If the reference is a cell, it returns the row
number of the cell. If the reference is a cell
range, it returns the corresponding row
numbers in a one-column Array if the
formula is entered as an array formula. If the
ROW function with a range reference is not
Appendix B Description of Functions 473