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
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
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.
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
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