Lookup & Reference(Microsoft Excel Functions)

01/25/2023

Search functions.

LOOKUP Series.

XLOOKUP function. Searching for data.

XLOOKUP function. Searching for data.(Microsoft Excel)

VLOOKUP function. Searching for data.

VLOOKUP function. Searching for data.(Microsoft Excel)

HLOOKUP function. Searching for data.

HLOOKUP function. Searching for data.(Microsoft Excel)

Others.

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

INDEX Function. Retrieves values by specifying range of cells, number of rows, and number of columns.(Microsoft Excel)

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

MATCH Function. Obtains the relative position of a cell as a result of a search.(Microsoft Excel)

FILTER function. Get all rows matching the condition.

FILTER function. Get all rows matching the condition.(Microsoft Excel)

Functions to edit range of cells based on a value.

SORT Function. Sort range of cells.

SORT Function. Sort range of cells.(Microsoft Excel)

SORTBY Function. Sort range of cells.

SORTBY Function. Sort range of cells.(Microsoft Excel)

UNIQUE function. Remove duplicates in range of cells.

UNIQUE function. Remove duplicates in range of cells.(Microsoft Excel)

Functions to edit range of cells regardless of their values.

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

DROP Function. Deletes rows and columns from range of cells.(Microsoft Excel)

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

TAKE Function. Get rows and columns from range of cells.(Microsoft Excel)

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

TOCOL Function. Sort range of cells into a single column.(Microsoft Excel)

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

TOROW Function. Sort range of cells into a single row.(Microsoft Excel)

EXPAND Function. Expand range of cells.

EXPAND Function. Expand range of cells.(Microsoft Excel)

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

CHOOSEROWS and CHOOSECOLS functions. Obtain rows and columns at specified positions from range of cells.(Microsoft Excel)

VSTACK and HSTACK functions.Merge multiple range of cells.

VSTACK and HSTACK functions.Merge multiple range of cells.(Microsoft Excel)

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

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.

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