ADDRESS function
ADDRESS returns a cell address (reference) as text, according to the specified row and column numbers. Optionally, you can determine how the address is interpreted. The address can be interpreted as an absolute address (for example, $A$1), a relative address (as A1), or as a mixed form (A$1 or $A1). You can also specify the name of the sheet.

COLUMN function
COLUMN returns the column number of a cell reference.

COLUMNS function
COLUMNS returns the column number of a cell reference.

HLOOKUP function
HLOOKUP searches for a value and reference to the cells under 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, which is named in the index, in the same column.

HYPERLINK function
HYPERLINK opens a hyperlink when you click the cell that contains the hyperlink. If you use the optional

*celltext* argument, the formula locates the URL, and then the text or number is displayed.

INDEX function
INDEX returns the contents of a cell, specified by row and column number or an optional range name.

INDIRECT function
INDIRECT returns the reference specified by a text string. Use this function if you want a formula to always refer to a particular cell address, regardless of the contents of the cell after rows or cells have been moved or deleted. This function can also be used to return the area of a corresponding string.

OFFSET function
OFFSET returns the value of a cell the location of which is offset by a certain number of rows and columns.

ROW function
ROW returns the row number of a cell reference.

ROWS function
ROWS returns the number of rows in a reference or array.

SHEET function
SHEET returns the sheet number of a reference or a string representing a sheet name. If you do not enter any parameters, the result is the sheet number of the spreadsheet containing the formula.

VLOOKUP function
VLOOKUP uses a vertical search with reference to adjacent cells to the right.