Forum Discussion
Volume range, apply % in formula
Yes, it works. In your sample there are values within the range. In general LOOKUP function - Microsoft Support
However, it'll be an error if the volume value is less than 100000. If that's the case, add to your volume ranges the one from zero to 100000. Another point, volume ranges are to be in ascending order.
To be more flexible you may use XLOOKUP function - Microsoft Support, variant for it is attached file.
Thank you SergeiBaklan . However, with the lookup formula - my lookup value has to match exactly. What if the value I'm looking up is only "within the range"? Can this formula also apply? Thank you!
Yes, it works. In your sample there are values within the range. In general LOOKUP function - Microsoft Support
However, it'll be an error if the volume value is less than 100000. If that's the case, add to your volume ranges the one from zero to 100000. Another point, volume ranges are to be in ascending order.
To be more flexible you may use XLOOKUP function - Microsoft Support, variant for it is attached file.