How to return a result between two values? With the XLOOKUP function, you can search in both directions, smaller or larger.
calculate between 2 values
When you start learning Excel, it's important to understand how you can reuse the content of other cells in your formula. It's very easy.