Module lookup 

Lookup and reference formula functions: VLOOKUP, HLOOKUP, INDEX, MATCH, LOOKUP, ROW, COLUMN, ROWS, COLUMNS, CHOOSE, ADDRESS.

Functions

fn_address

ADDRESS(row_num, column_num, [abs_num], [a1], [sheet_text])

fn_choose

CHOOSE(index_num, value1, [value2], …) - returns value at given index.

fn_column

COLUMN(reference) - returns the column number of a reference.

fn_columns

COLUMNS(array) - returns the number of columns in a reference.

fn_hlookup

HLOOKUP(lookup_value, table_array, row_index_num, [range_lookup])

fn_index

INDEX(array, row_num, [col_num])

fn_lookup

LOOKUP(lookup_value, lookup_vector, [result_vector]) - vector form.

fn_match

MATCH(lookup_value, lookup_array, [match_type])

fn_row

ROW(reference) - returns the row number of a reference.

fn_rows

ROWS(array) - returns the number of rows in a reference.

fn_vlookup

VLOOKUP(lookup_value, table_array, col_index_num, [range_lookup])