# Excel Lookup/Reference Functions

## Excel XLOOKUP Function

Excel XLOOKUP Function was added into Excel as a beta feature in August 2019 and is now accessible exclusively in Microsoft 365. (as of July 2021). However, if you fall into this category and often deal with big sets of data in Excel, understanding this method is worthwhile. In this lesson, we will demonstrate how… read more »

## Excel UNIQUE Function

The guide demonstrates how to use the UNIQUE function and dynamic arrays in Excel to create unique values. You’ll learn how to use a basic formula to locate unique values inside a column or row, across many columns, and depending on criteria, among other things. Excel 365’s introduction of the Excel UNIQUE formula altered everything!… read more »

## Excel SORT Function

The excel sort function is one of the most useful new features in Excel. It is one of many functions that make advantage of Excel’s new dynamic array calculation engine, which enables Excel to spill results from a single formula across numerous cells. SORT function in Excel The SORT function in Excel sorts the contents… read more »

## Excel TRANSPOSE Function

Excel TRANSPOSE formula allows you to rotate (swap) values from rows to columns and vice versa in Excel. Its goal, as a component of the Excel lookup and reference functions, is to arrange data in the appropriate manner. To run the formula, pick the precise size of the transposed range and hit the CSE key… read more »

## Excel Vlookup Function

This post will guide you how to use Excel VLOOKUP function with syntax and examples in Microsoft excel. Description The Excel VLOOKUP function lookup a value in the first column of the table and return the value in the same row based on index_num position. The VLOOKUP function is a build-in function in Microsoft Excel and… read more »

## Excel Rows Function

This post will guide you how to use Excel ROWS function with syntax and examples in Microsoft excel. Description The Excel ROWS function returns the number of rows in a cell reference. The ROWS function is a build-in function in Microsoft Excel and it is categorized as a Lookup and Reference Function. The ROWS function is available… read more »

## Excel Row Function

This post will guide you how to use Excel ROW function with syntax and examples in Microsoft excel. Description The Excel ROW function returns the row number of a cell reference. The ROW function is a build-in function in Microsoft Excel and it is categorized as a Lookup and Reference Function. The ROW function is… read more »

## Excel Match Function

This post will guide you how to use Excel MATCH function with syntax and examples in Microsoft excel. Description The Excel MATCH function search a value in an array and returns the position of that item. The MATCH function is a build-in function in Microsoft Excel and it is categorized as a Lookup and Reference Function…. read more »

## Excel Lookup Function

This post will guide you how to use Excel LOOKUP function with syntax and examples in Microsoft excel. Description The Excel LOOKUP function will search a value in a vector or array. The LOOKUP function is a build-in function in Microsoft Excel and it is categorized as a Lookup and Reference Function. The LOOKUP function is available… read more »

## Excel Indirect Function

This post will guide you how to use Excel INDIRECT function with syntax and examples in Microsoft excel. Description The Excel INDIRECT function returns the cell reference based on a text string, such as: type the text string “A2” in B1 cell, it just a text string, so you can use INDIRECT function to convert… read more »

## Excel Index Function

This post will guide you how to use Excel INDEX function with syntax and examples in Microsoft excel. Description The Excel INDEX function returns a value from a table based on the index (row number and column number). You can use INDEX function to extract entire rows or entire columns. This function is used to… read more »

## Excel Hyperlink Function

This post will guide you how to use Excel HYPERLINK function with syntax and examples in Microsoft excel. Description The Excel HYPERLINK function creates a shortcut/hyperlink to a document, when you click this hyperlink, the excel will open the file that is stored on a network server or local location. ​The HYPERLINK function is a build-in function in Microsoft Excel and… read more »

## Excel Hlookup Function

This post will guide you how to use Excel HLOOKUP function with syntax and examples in Microsoft excel. Description The Excel HLOOKUP function lookup a value in the top row of the table and return the value in the same column based on index_num position. The HLOOKUP function is a build-in function in Microsoft Excel and… read more »

## Excel Columns Function

This post will guide you how to use Excel COLUMNS function with syntax and examples in Microsoft excel. Description The Excel COLUMNS function returns the number of columns in an Array or a reference. The COLUMNS function is a build-in function in Microsoft Excel and it is categorized as a Lookup and Reference Function. The COLUMNS function… read more »

## Excel Column Function

This post will guide you how to use Excel COLUMN function with syntax and examples in Microsoft excel. Description The Excel COLUMN function returns the first column number of the given cell reference. The COLUMN function is a build-in function in Microsoft Excel and it is categorized as a Lookup and Reference Function. The COLUMN function is… read more »

## Excel Choose Function

This post will guide you how to use Excel CHOOSE function with syntax and examples in Microsoft excel. Description The Excel CHOOSE function returns a value from a list of values. The CHOOSE function is a build-in function in Microsoft Excel and it is categorized as a Lookup and Reference Function. The CHOOSE function is available in… read more »

## Excel Areas Function

This post will guide you how to use Excel AREAS function with syntax and examples in Microsoft excel. Description The Excel AREAS function returns the number of ranges in a reference. The AREAS function is a build-in function in Microsoft Excel and it is categorized as a Lookup and Reference Function. The AREAS function is available in… read more »

## Excel Address Function

This post will guide you how to use Excel ADDRESS function with syntax and examples in Microsoft excel. Description The Excel ADDRESS function returns a reference as a text string to a single cell. The ADDRESS function is a build-in function in Microsoft Excel and it is categorized as a Lookup and Reference Function. The ADDRESS function… read more »

Sidebar