Lookup and reference functions
How to use the MAKEARRAY function
The MAKEARRAY function returns an array with a specific number of rows and columns calculated by applying a LAMBDA function. […]
How to use the STOCKHISTORY function
The STOCKHISTORY function lets you get stock prices based on a stock quote. It is in the Lookup and reference […]
How to use the XMATCH function
This article demonstrates the XMATCH function introduced in Excel 365. The XMATCH function is an enhanced version of the MATCH […]
How to use the XLOOKUP function
This article demonstrates how to use the XLOOKUP function in Excel 365. Table of Contents XLOOKUP function - example Function […]
How to use the SORTBY function
The SORTBY function allows you to sort values from a cell range or array based on a corresponding cell range […]
The SORT function lets you sort values from a cell range or array. It returns an array with a size […]
How to use the FILTER function
The FILTER function lets you extract values/rows based on a condition or criteria. It is in the Lookup and reference category […]
How to use the UNIQUE function
The UNIQUE function is a very versatile Excel function, it lets you extract both unique and unique distinct values and […]
What is the AREAS function? The AREAS function returns the number of cell ranges and single cells in the specified […]
How to use the FORMULATEXT function
What is the FORMULATEXT function? The FORMULATEXT function returns a formula as a text string, it was introduced in Excel […]
How to use the COLUMNS function
What is the COLUMNS function? The COLUMNS function allows you to calculate the number of columns in a cell range […]
The ROWS function allows you to calculate the number of rows in a cell range. The example above shows that cell […]
How to use the COLUMN function
The COLUMN function returns the column number of the top-left cell of a cell reference. If the argument is not […]
How to use the ADDRESS function
The ADDRESS function returns the address of a specific cell, you need to provide a row and column number. Table […]
How to use the CHOOSE function
The CHOOSE function lets you get a value based on a number, the number determines which value to get. The […]
How to use the HYPERLINK function
What is the HYPERLINK function? The HYPERLINK function allows you to build a link in a cell pointing to something […]
How to use the HLOOKUP function
What is the HLOOKUP function? The HLOOKUP function lets you search the top row in a data range for a […]
How to use the VLOOKUP function
The VLOOKUP function lets you search the leftmost column for a value and return another value on the same row […]
How to use the TRANSPOSE function
The TRANSPOSE function allows you to convert a vertical range to a horizontal range, or vice versa. A vertical range […]
How to use the LOOKUP function
Finds a value in a sorted cell range and returns a value on the same row.
How to use the INDIRECT function
The INDIRECT function returns the cell reference based on a text string and shows the content of that cell reference. […]
The ROW function calculates the row number of a cell reference. What is on this page? ROW Function Syntax ROW […]
Identify the position of a value in an array.
Gets a value in a specific cell range based on a row and column number.
How to use the OFFSET function
The OFFSET function returns a reference to a range that is a given number of rows and columns from a […]