# How to find where in the interval a number is

Imagine we have 3 columns, the first two define a range (e.g. min and max weight) and the third the value (e.g. price that item costs if it has that weight).

What formula should be used to achieve this?

From this site I was able to build something that returns the number of the column, but I would now need to get column C.
To get the column number I use =IF(SUMPRODUCT(--(A1:A39<=F2)*(B1:B39>=F2))=1,SUMPRODUCT(--(A1:A39<=F2)*(B1:B39>=F2),ROW(A1:A39))-1,"Not Found")

here is an example file: https://drive.google.com/file/d/1yJGc...

**Questions:**

- How would I retrieve the corresponding value in C?
- Is there an easier way to do this?

The world isn't organized in steps of one hundredth.

Assume you intervals left side closed, right side open. The first row e.g. covering

`1.10 <= value < 1.50`

, the next interval then being`1.50 <= value < 2.00`

.If actually only occur values gtting integer when multiplied with 100 this won't spoil anything.

Anyway the column of upper limits is superfluous.

I agree. The real world example actually

isorganised in steps of one hundredth (it is a cost and they don't define less than one cent of euro), but I agree that from the calculation's point of view the upper limit is not needed.