June 20, 2021

## How to use MATCH Function in Excel

MATCH is an Excel function used to locate the position of a lookup value in a row, column, or table. MATCH supports approximate and exact …

## How to use INDIRECT Function in Excel

The Excel INDIRECT function returns a valid reference from a given text string. Use INDIRECT when you need to convert a reference assembled as text …

## How to use HYPERLINK Function in Excel

The Excel HYPERLINK function returns a hyperlink from a given destination and “friendly name”. You can use HYPERLINK to construct a clickable hyperlink with a …

## How to use HLOOKUP Function in Excel

HLOOKUP is an Excel function to lookup and retrieve data from a specific row in table. The “H” in HLOOKUP stands for “horizontal”, where lookup …

## How to use FORMULATEXT Function in Excel

The Excel FORMULATEXT function returns a formula as a text string from given reference. You can use FORMULATEXT to extract a formula as text from …

## How to use GETPIVOTDATA Function in Excel

The Excel GETPIVOTDATA function can query a pivot table and retrieve specific data based on the pivot table structure, instead of cell references. Syntax:= GETPIVOTDATA …

## How to use COLUMNS Function in Excel

COLUMNS function is a built-in function in Microsoft Excel. It falls under the category of Lookup Functions in Excel. COLUMNS Function returns the total number …

## How to use COLUMN Function in Excel

Column function in excel is used to find out the column numbers of the target cells in excel, it is also a built in worksheet function …

## How to use AREAS Function in Excel

The Excel AREAS function returns the number of areas in a given reference. For example, =AREAS((A1:C1,A2:C2)) returns 2. Multiple references must be enclosed in an …

## How to use ADDRESS Function in Excel

Address function in excel is used to find the address of the cell and the value returned by this function is absolute, it is an inbuilt …