Lookup and Reference Functions

Status	Description	Function	Text	Formular
Done	📎 ADDRESS function	ADDRESS function	Returns a reference as text to a single cell in a worksheet	`ADDRESS(row_num, column_num, [abs_num], [a1], [sheet_text])`
Done	📎 INDIRECT Function	`INDIRECT function`	Returns a reference indicated by a text value	`INDIRECT(ref_text, [a1])`
Done	📎 OFFSET Function	`OFFSET function`	Returns a reference offset from a given reference	OFFSET(reference, rows, cols, [height], [width])
Done	📎 INDEX Function	INDEX function	Uses an index to choose a value from a reference or array	`INDEX(array, row_num, [column_num])`
Done	📎 MATCH function	MATCH function	Returns a position of the values	`MATCH(lookup_value, lookup_array, [match_type])`
Done	📎 ROW Function	ROW function	Returns the row number of a reference	`ROW([reference])`
Done	📎 ROWS Function	ROWS function	Returns the number of rows in a reference	`ROWS(array)`
Done	📎 COLUMN function	COLUMN function	Returns the column number of a reference	`COLUMN([reference])`
Done	📎 COLUMNS Function	COLUMNS function	Returns the number of columns in a reference	`COLUMNS(array)`
Not started	📎 CHOOSE function	`CHOOSE function`	Chooses a value from a list of values
Not started	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	XMATCH function	XMATCH function	Returns the relative position of an item in an array or range of cells.	`XMATCH(lookup_value, lookup_array, [match_mode], [search_mode])`
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
Done	📎 XLOOKUP() Function	XLOOKUP function	Searches a range or an array, and returns an item corresponding to the first match it finds.	`= XLOOKUP(lookup_value, lookup_array, return_array, [if_not_found], [match_mode], [search_mode])`
Done	📎 VLOOKUP() Function	VLOOKUP function	Looks in the first column of an array and moves across the row to return the value of a cel	`= VLOOKUP(lookup_value, table_array, col_index_num, [range_lookup])`
Done	📎 HLOOKUP() Function	HLOOKUP function	Looks in the top row of an array and returns the value of the indicated cell
Not started	Looks up values in a vector or array	LOOKUP function