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.