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.