UNIQUE Function

UNIQUE Function

The Excel UNIQUE function is a lookup and reference formula that returns a list of unique values from a list or range. This formula is one of the newest Dynamic Array functions to be released with Excel 2019. In this guide, we’re going to show you how to use the Excel...
Function: MATCH

Function: MATCH

Excel MATCH function is a lookup/reference formula that returns the relative position of a lookup value from a specified range. The position can be used as the index value in other lookup functions. In this guide, we’re going to show you how to use the Excel MATCH...
Function: INDEX

Function: INDEX

The Excel INDEX function returns a value or the reference of a value at a given position in a range or array. The INDEX function has two different forms to return a value or a reference. Using an array form returns a value, while a reference form returns a reference....

How to speed up lookup formulas

Lookup functions are extremely useful when working with large data sets. Although they almost always work instantaneously with small data, larger data sets is when things can get rough in terms of performance, as large operations can require more computational power....
Function: IFS

Function: IFS

The IFS function evaluates multiple conditions until finding first TRUE condition. It is intended to replace nested IF statements containing multiple IF functions. In this guide, we’re going to show you how to use the IFS function and also go over some tips and error...
Function: SWITCH

Function: SWITCH

The SWITCH function evaluates the value in its first argument against the value-result pairs defined with them, and returns the matched pair if there is a match, and the default value if there isn’t. The SWITCH function is a good alternative to the IF function...
Function: MIRR

Function: MIRR

The MIRR Excel function is a finance function that calculates the modified internal rate of return (MIRR) for a series of periodic cash flows. This function works by using both the cost of the investment and the interest received by reinvesting the cash. In this...