Category: Excel Function

The OFFSET function returns a cell or data range that is specified by the number of rows and columns relative to another cell or data range. Formula: = OFFSET(reference, …

The MATCH function returns the relative position for a value in the data range you specified. Formula: = MATCH(lookup_value, lookup_array, ) Explanation: Lookup_value is required, the value to search …

The CHOOSE function is to return a value from a list with the index number you specified. Formula: = CHOOSE(index_num, value1, , …) Explanation: Index_num is required, the number …

The INDIRECT function is to return the reference you specified by a text string. INDIRECT function can change the reference to a cell without changing the formula. Formula: = …

The INDEX function is to return the value of a data array, which is selected by the row and column number. Formula: = INDEX(array, row_num, ) Explanation: Array is …

The HYPERLINK function creates a shortcut to open a document stored on a network server, an intranet or the Internet. Formula: = HYPERLINK(link_location, ) Explanation: Link_location is required, the …