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 returns the column number of a cell reference.
COLUMNS returns the column number of a cell reference.
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 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 returns the contents of a cell, specified by row and column number or an optional range name.
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 returns the value of a cell the location of which is offset by a certain number of rows and columns.
ROW returns the row number of a cell reference.
ROWS returns the number of rows in a reference or array.
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 uses a vertical search with reference to adjacent cells to the right.