Lookup & Reference(Microsoft Excel Functions)

01/25/2023

Search functions.

LOOKUP Series.

XLOOKUP function. Searching for data.

VLOOKUP function. Searching for data.

HLOOKUP function. Searching for data.

Others.

INDEX Function. Retrieves values by specifying range of cells, number of rows, and number of columns.

MATCH Function. Obtains the relative position of a cell as a result of a search.

FILTER function. Get all rows matching the condition.

Functions to edit range of cells based on a value.

SORT Function. Sort range of cells.

SORTBY Function. Sort range of cells.

UNIQUE function. Remove duplicates in range of cells.

Functions to edit range of cells regardless of their values.

DROP Function. Deletes rows and columns from range of cells.

TAKE Function. Get rows and columns from range of cells.

TOCOL Function. Sort range of cells into a single column.

TOROW Function. Sort range of cells into a single row.

EXPAND Function. Expand range of cells.

CHOOSEROWS and CHOOSECOLS functions. Obtain rows and columns at specified positions from range of cells.

VSTACK and HSTACK functions.Merge multiple range of cells.

WRAPROWS and WRAPCOLS functions. Sort specified range of cells in a single column or row by a specified number of rows or columns.

OFFSET Function. Get a cell by specifying the distance from the reference cell, height and width.