Creates a cell address as text, given specified row and column numbers.
Tags:
access:
public
Parameters:
row
$row
Row number to use in the cell reference
column
$column
Column number to use in the cell reference
relativity
$relativity
Flag indicating the type of reference to return
or omitted Absolute
Absolute row; relative column
Relative row; absolute column
Relative
referenceStyle
$referenceStyle
A logical value that specifies the A1 or R1C1 reference style. TRUE or omitted CELL_ADDRESS returns an A1-style reference FALSE CELL_ADDRESS returns an R1C1-style reference
Returns the column number of the given cell reference If the cell reference is a range of cells, COLUMN returns the column numbers of each column in the reference as a horizontal array. If cell reference is omitted, and the function is being called through the calculation engine, then it is assumed to be the reference of the cell in which the COLUMN function appears; otherwise this function returns 0.
Tags:
return:
or array of integer
access:
public
Parameters:
cellAddress
$cellAddress
A reference to a range of cells for which you want the column numbers
Uses an index to choose a value from a reference or array implemented: Return the value of a specified cell or array of cells Array form not implemented: Return a reference to specified cells Reference form
Tags:
access:
public
Parameters:
range_array
$arrayValues
a range of cells or an array constant
row_num
$rowNum
selects the row in array from which to return a value. If row_num is omitted, column_num is required.
column_num
$columnNum
selects the column in array from which to return a value. If column_num is omitted, row_num is required.
Returns a reference to a range that is a specified number of rows and columns from a cell or range of cells. The reference that is returned can be a single cell or a range of cells. You can specify the number of rows and the number of columns to be returned.
Tags:
return:
A reference to a cell or range of cells
access:
public
Parameters:
cellAddress
$cellAddress
The reference from which you want to base the offset. Reference must refer to a cell or range of adjacent cells; otherwise, OFFSET returns the #VALUE! error value.
rows
$rows
The number of rows, up or down, that you want the upper-left cell to refer to. Using 5 as the rows argument specifies that the upper-left cell in the reference is five rows below reference. Rows can be positive (which means below the starting reference) or negative (which means above the starting reference).
cols
$columns
The number of columns, to the left or right, that you want the upper-left cell of the result to refer to. Using 5 as the cols argument specifies that the upper-left cell in the reference is five columns to the right of reference. Cols can be positive (which means to the right of the starting reference) or negative (which means to the left of the starting reference).
height
$height
The height, in number of rows, that you want the returned reference to be. Height must be a positive number.
width
$width
The width, in number of columns, that you want the returned reference to be. Width must be a positive number.
Returns the row number of the given cell reference If the cell reference is a range of cells, ROW returns the row numbers of each row in the reference as a vertical array. If cell reference is omitted, and the function is being called through the calculation engine, then it is assumed to be the reference of the cell in which the ROW function appears; otherwise this function returns 0.
Tags:
return:
or array of integer
access:
public
Parameters:
cellAddress
$cellAddress
A reference to a range of cells for which you want the row numbers
VLOOKUP The VLOOKUP function searches for value in the left-most column of lookup_array and returns the value in the same row based on the index_number.
Tags:
return:
The value of the found cell
access:
public
Parameters:
lookup_value
$lookup_value
The value that you want to match in lookup_array
lookup_array
$lookup_array
The range of cells being searched
index_number
$index_number
The column number in table_array from which the matching value must be returned. The first column is 1.
not_exact_match
$not_exact_match
Determines if you are looking for an exact match based on lookup_value.
