🎗️

Lookup and Reference Functions

Description	Function	Status
Returns the specified columns from an array	CHOOSECOLS function	Not started
Returns the specified rows from an array	CHOOSEROWS function	Not started
Excludes a specified number of rows or columns from the start or end of an array	DROP function	Not started
Expands or pads an array to specified row and column dimensions	EXPAND function	Not started
Filters a range of data based on criteria you define	FILTER function	Not started
Returns the formula at the given reference as text	FORMULATEXT function	Not started
Returns data stored in a PivotTable report	GETPIVOTDATA function	Not started
Appends arrays horizontally and in sequence to return a larger array	HSTACK function	Not started
Creates a shortcut or jump that opens a document stored on a network server, an intranet, or the Internet	HYPERLINK function	Not started
Returns an image from a given source	IMAGE function	Not started
Retrieves real-time data from a program that supports COM automation	RTD function	Not started
Sorts the contents of a range or array	SORT function	Not started
Sorts the contents of a range or array based on the values in a corresponding range or array	SORTBY function	Not started
Returns a specified number of contiguous rows or columns from the start or end of an array	TAKE function	Not started
Returns the array in a single column	TOCOL function	Not started
Returns the array in a single row	TOROW function	Not started
Returns the transpose of an array	TRANSPOSE function	Not started
Returns a list of unique values in a list or range	UNIQUE function	Not started
Appends arrays vertically and in sequence to return a larger array	VSTACK function	Not started
Wraps the provided row or column of values by columns after a specified number of elements	WRAPCOLS function	Not started
Wraps the provided row or column of values by rows after a specified number of elements	WRAPROWS function	Not started

Reference and Address Functions (Learn these first – essential for understanding dynamic referencing)

Name	Formular	Function	Status	Text
♟️ ADDRESS function	`ADDRESS(row_num, column_num, [abs_num], [a1], [sheet_text])`	ADDRESS function	Done	Returns a reference as text to a single cell in a worksheet
📎 INDIRECT Function	`INDIRECT(ref_text, [a1])`	`INDIRECT function`	Done	Returns a reference indicated by a text value
📎 INDEX Function	`INDEX(array, row_num, [column_num])`	INDEX function	Done	Uses an index to choose a value from a reference or array
📎 OFFSET Function	OFFSET(reference, rows, cols, [height], [width])	`OFFSET function`	Done	Returns a reference offset from a given reference
📎 COLUMNS Function	`COLUMNS(array)`	COLUMNS function	Done	Returns the number of columns in a reference
📎 CHOOSE function		`CHOOSE function`	Not started	Chooses a value from a list of values
📎 COLUMN function	`COLUMN([reference])`	COLUMN function	Done	Returns the column number of a reference
📎 ROWS Function	`ROWS(array)`	ROWS function	Done	Returns the number of rows in a reference
📎 MATCH function	`MATCH(lookup_value, lookup_array, [match_type])`	MATCH function	Done	Returns a position of the values
📎 ROW Function	`ROW([reference])`	ROW function	Done	Returns the row number of a reference

2. Lookup and Match Functions (Core for data retrieval and financial modeling)

Name	Formular	Function	Status	Text
📎 VLOOKUP() Function	`= VLOOKUP(lookup_value, table_array, col_index_num, [range_lookup])`	VLOOKUP function	Done	Looks in the first column of an array and moves across the row to return the value of a cel
📎 HLOOKUP() Function		HLOOKUP function	Done	Looks in the top row of an array and returns the value of the indicated cell
📎 XLOOKUP( ) Function	`= XLOOKUP(lookup_value, lookup_array, return_array, [if_not_found], [match_mode], [search_mode])`	XLOOKUP function	Done	Searches a range or an array, and returns an item corresponding to the first match it finds.
LOOKUP function	`Looks up values in a vector or array`	LOOKUP function	Not started
XMATCH function	`XMATCH(lookup_value, lookup_array, [match_mode], [search_mode])`	XMATCH function	Not started	Returns the relative position of an item in an array or range of cells.

Lookup and Reference Functions

Reference and Address Functions (Learn these first – essential for understanding dynamic referencing)

T1

2. Lookup and Match Functions (Core for data retrieval and financial modeling)

T2