A function in Excel is a preset formula, that helps perform mathematical, statistical, and logical operations. Worksheet functions are categorized by their functionality.

Lookup & Reference Functions

Excel Lookup and Reference functions help you to work with arrays of data, and are particularly useful when you need to cross reference between different data sets. Please clink in "Example" to see full description of the function, with examples of use and details of common errors.

Functions Syntax Tutorial
ROW Function ROW(reference) Example
ROWS Function ROWS(array) Example
COLUMN Function COLUMN(reference) Example
COLUMNS Function COLUMNS(array) Example
INDIRECT Function INDIRECT(ref_text,C1) Example
VLOOKUP Function VLOOKUP(lookup_value,table_array, col_index_num, range_lookup) Example
HLOOKUP Function HLOOKUP(lookup_value, table_array, row_index_num, range_lookup) Example
INDEX Function INDEX(array,row_num, column_num) Example
MATCH Function MATCH(lookup_value, lookup_array, match_type) Example
Excel OFFSET Function OFFSET(reference, row, cols, [height], [width]) Example