Lookup functions

Lookup functions can manage your data in your worksheets like in a database. Discover those techniques in these articles

How to use the VLOOKUP function?

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

The VLOOKUP function helps you to return a result between 2 values. Discover how in this article.

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

You can replace the third argument of your VLOOKUP function with a MATCH function to create a dynamic formula to research your data

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

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

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

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

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

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

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

You can easily find all your duplicate values in a column with a simple formula and 2 Excel functions; FILTER and COUNTIF

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

1 2