New offer! Get 30% off one whole year of Unlimited learning. Subscribe for just £249.99 £174.99. New subscribers only. T&Cs apply

## Approximate match with XLOOKUP

Approximate match options in XLOOKUP adds a lot of flexibility to your lookup function. Make sure you have downloaded the workbook and can carry out all of the steps shown …

## SORT or SORTBY

The SORT function and SORTBY function will allow you to sort data, but both have very different use cases. The SORT function will sort a list but the SORTBY function …

## Conditional Calculations

Excel has functions that allow for conditional calculations. These are calculations with conditions or criteria attached. These functions include SUMIF and AVERAGEIFS. Functions with IF and IFS attached are widely …

## 6 Reasons to use Tables in Excel

Quick totals. If you need to get totals quickly, convert your data into a table and the totals will be calculated for you. Quick formatting. You can quickly format a …

## Logical tests, Comparative Operators and IF statements

Logical tests give a True or False statement and these can be calculated with the use of comparative operators.  A logical test can be a comparison between two cell references …

## How to lookup to the left

How can I lookup to the left? One of the limitations posed by VLOOKUP is that it can only look up to the right. But what if you want to …

## Creating a Unique List in Excel

In this article, we are going to explore the first of our new Dynamic Array functions. The UNIQUE function. As the name describes, the UNIQUE function will allow you to …