XLOOKUP

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

This article explains how to connect a slicer with your data type fields. Only 2 formulae are necessary for this trick

How to return a result in a range of values? With the XLOOKUP function, you can search in both direction, smaller or larger.

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 the new Excel function to find data in a reference table. The function merge the benefits of VLOOKUP and INDEX