MATCH is an Excel function used to locate the position of a lookup value in a row, column, or table. …
Category: Lookup and reference
The Excel INDIRECT function returns a valid reference from a given text string. Use INDIRECT when you need to convert …
The Excel HYPERLINK function returns a hyperlink from a given destination and “friendly name”. You can use HYPERLINK to construct …
HLOOKUP is an Excel function to lookup and retrieve data from a specific row in table. The “H” in HLOOKUP …
The Excel FORMULATEXT function returns a formula as a text string from given reference. You can use FORMULATEXT to extract …
The Excel GETPIVOTDATA function can query a pivot table and retrieve specific data based on the pivot table structure, instead …
COLUMNS function is a built-in function in Microsoft Excel. It falls under the category of Lookup Functions in Excel. COLUMNS …
Column function in excel is used to find out the column numbers of the target cells in excel, it is also …
The Excel AREAS function returns the number of areas in a given reference. For example, =AREAS((A1:C1,A2:C2)) returns 2. Multiple references …
Address function in excel is used to find the address of the cell and the value returned by this function is …