Formulas

VLOOKUP: VLOOKUP is used to get the data for a lookup value in the leftmost column of a section of your spreadsheet called the table array on the base index_number (column number).

HLOOKUP: HLOOKUP is used to get the data for a lookup value in the top most row of a section of your spreadsheet called the table array on the base index_number (row number).

MATCH: This formula searches for a value in an array and returns the relative position of that item

INDEX: This formula gets a value from a table on the base of given row and column parameter.

INDIRECT: This formula returns the reference to a cell or range on the base of its string parameter.

OFFSET: This formula returns a reference to a range that is offset number of rows and columns.

CHOOSE: This formula gets a value from an array list on the based on given parameter.

ADDRESS: This formula returns a cell address in text format.

String/Text Functions

FIND: This formula returns a position of text or character in a text. This is a case sensitive.

LEN: This formula returns the number of characters (including space) of a text.

MID: This function returns a part of text or a character form a text on the base of parameter.

SUBSTITUTE: This formula replaces the fully or partially text with another text on the base parameter

TEXT: This formula returns a value converted to text with a specified format on the base of parameter.

TEXTJOIN: This formula is used to combine 2 or more texts together separated by a delimiter as given in the parameter.

TRIM: This formula removes the leading and trailing spaces from a text.

Date/Time Functions

DATE: This formula returns the create a date from given parameter of year, month and day.

DATEVALUE: This formula converts the text (should be in form of date) into a date.

EOMONTH: This formula calculates the last day of the month after adding a specified number of months to a date as given in the parameter.

NETWORKDAYS: This formula returns the number of work days between 2 dates, excluding Saturday and Sunday and holidays.

NOW: This formula returns the current system date and time

TODAY: This formula returns the current system date only.

Others

AVERAGEIF: This formula returns the average of all numbers in a range of cells, on the base of given criteria in the parameter.

COUNTIF: This formula returns the number of cells in a range on the base of given criteria in the parameter.

COUNTIFS: This formula returns the number of cells in a range on the base of multiple criteria in the parameter.

SUMIF: This formula returns the total all numbers in a range of cells on the base of given criteria in the parameter.

SUMIFS: This formula returns the total all numbers in a range of cells on the base of multiple criteria in the parameter.

SUMPRODUCT: This formula sum of multiplies the corresponding items in the arrays.