Use this list of functions as a reference for each spreadsheet function.

- 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.