How to do a VLOOKUP on 2 columns There is two techniques to build a research based on 2 columns. One is with VLOOKUP and the other, the easiest, with XLOOKUP
How to use the INDEX function in Excel? Learn how to use the INDEX function in Excel. Step-by-step guide for beginners and experts to improve your data analysis skills.
VLOOKUP to the left in Excel 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
Search in a range of values with XLOOKUP How to return a result in a range of values? With the XLOOKUP function, you can search in both direction, smaller or larger.
Create a Lookup Offset When you have many times the same ID in your table, the following formula will help you to create a lookup offset.
XLOOKUP is a Formula 1 XLOOKUP is the new Excel function to find data in a reference table. The function merge the benefits of VLOOKUP and INDEX
How to use the MATCH function in Excel 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 VLOOKUP function? The VLOOKUP function helps you to return a specific value inside a table. How to use it? It's not difficult.
Calculate between two values The VLOOKUP function helps you to return a result between 2 values. Discover how in this article.
Compare 2 Columns You can easily compare the contain of 2 columns in Excel with the function VLOOKUP. You can also change the color for the missing values
Dynamic VLOOKUP research You can replace the third argument of your VLOOKUP function with a MATCH function to create a dynamic formula to research your data
Anonymise your data Discover how you can transform your worksheet to anonymise your data in the case you have sensitive data. 5 steps are needed