Formulas and Functions

Chapter 9 Reference Functions 207
Function Description
“LOOKUP” (page 217 ) The LOOKUP function nds a match for a given
search value in one range, and then returns the
value in the cell with the same relative position in
a second range.
“MATCH” (page 218) The MATCH function returns the position of a
value within a range.
“OFFSET” (page 219 ) The OFFSET function returns a range of cells that
is the specied number of rows and columns
away from the specied base cell.
“ROW” (page 221) The ROW function returns the row number of the
row containing a specied cell.
“ROWS” (page 221) The ROWS function returns the number of rows
included in a specied range of cells.
“TRANSPOSE” (page 222) The transpose function returns a vertical range of
cells as a horizontal range of cells, or vice versa.
“VLOOKUP” (page 223) The VLOOKUP function returns 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.
ADDRESS
The ADDRESS function constructs a cell address string from separate row, column, and
table identiers.
ADDRESS(row, column, addr-type, addr-style, table)
 row: The row number of the address. row is a number value that must be in the
range 1 to 65,535.
 column: The column number of the address. column is a number value that must
be in the range 1 to 256.
 addr-type: An optional value specifying whether the row and column numbers are
relative or absolute.
all absolute (1 or omitted): Row and column references are absolute.
row absolute, column relative (2): Row references are absolute and column
references are relative.
row relative, column absolute (3): Row references are relative and column
references are absolute.
all relative (4): Row and column references are relative.
 addr-style: An optional value specifying the address style.