Lookup and reference functions
How to use the MAKEARRAY function
What is the MAKEARRAY function? The MAKEARRAY function returns an array with a specific number of rows and columns calculated […]
How to use the STOCKHISTORY function
What is the STOCKHISTORY function? The STOCKHISTORY function lets you get stock prices based on a stock quote. It is […]
How to use the XMATCH function
What is the XMATCH function? The XMATCH function searches for a given value in a range of cells and then […]
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 […]
What is the ROWS function? The ROWS function allows you to calculate the number of rows in a cell range. […]
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
What is the TRANSPOSE function? The TRANSPOSE function allows you to convert a vertical range to a horizontal range, or […]
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. […]
What is the ROW function? The ROW function calculates the row number of a cell reference. What is on this […]
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
What is the OFFSET function? The OFFSET function returns a reference to a range that is a given number of […]