Hlookup with range of values

[cancansova]

Hi, I'm trying to do an Hlookup based on the attached table.

Problem is that each column is for a range of values. If I do an hlookup without an exact match that works sometimes, but not always. Since the formula picks the closest value, if sometimes picks the upper bound of the wrong range since that is closer to the value than the upperbound of the correct range.

=HLOOKUP(F1,$A$2:$D$3,2)

For example, when F1 is 9,001 I'd like to the formula to return "8", but it returns "7". Any thoughts?

Thanks!!

 

[Cubist]

There's no attached table.