Function XLOOKUP in Excel
How to use the XLOOKUP function of Excel? It's a combination of the VLOOKUP and INDEX functions. Look at this article.
XLOOKUP
Transform List to Double-entry Table
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
Excel formula to search between two values
How to return a result between two values? With the XLOOKUP function, you can search in both directions, smaller or larger.
Connect slicer with Data Type
This article explains how to connect a slicer with your data type fields. Only 2 formulae are necessary for this trick
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
The 10 most useful Excel Functions in 2023
What are the 10 most useful Excel functions that you need to know? This article presents them with examples.
Return a result between 2 values
How to return a result between two values? With the XLOOKUP function, you can search in both directions, smaller or larger.