Lookup functions

Learn how to use lookup functions to analyze data in your worksheets. Our articles provide step-by-step guides and tips for mastering this technique

Create a Dynamic VLOOKUP function

Learn how to create a dynamic VLOOKUP with the MATCH function and customize your search criteria to return accurate results in Excel.

How to return a result between two values? With the XLOOKUP function, you can search in both directions, smaller or larger.

Unravel the mystery behind the #N/A error in VLOOKUP formulas. Learn how to identify and fix common mistakes that lead to this error

Unlock the secrets of finding duplicate values in Excel effortlessly. Find out how to use FILTER and COUNTIF functions

How to use the XLOOKUP function of Excel? It's a combination of the VLOOKUP and INDEX functions. Look at this article.

The VLOOKUP function helps you to return a specific value inside a table. How to use it? It's not difficult.

There is two techniques to build a research based on 2 columns. One is with VLOOKUP and the other, the easiest, with XLOOKUP

Learn how to use the INDEX function in Excel. Step-by-step guide for beginners and experts to improve your data analysis skills.

Learn how to compare two columns in Excel efficiently using simple techniques. Easy-to-follow guide with clear explanations and examples.

The function VLOOKUP is not able to return a value on the left of the search column. But you can do the job with XLOOKUP or INDEX MATCH

How to convert a list of data to a double-entry table? Only one function is needed to do the job. See the technique in this article

When you have many times the same ID in your table, the following formula will help you to create a lookup offset.

The MATCH function returns the position of an item in a list. This function is very useful to create DYNAMIC dashboard and formulas

Discover how you can transform your worksheet to anonymise your data in the case you have sensitive data. 5 steps are needed