I'm looking to index all of the values that fall between a range.

For two of the categories, I can return what I am looking for because it is only one conditional <1.5 and >6, but If I am trying to return the data with an identifier between 1.5 and 2, I am not sure how to revise my formula.

Below is what I have used to return the values for <1.5 and >6 and it has worked fine. How does it need to be adjusted?

AF1 is the cell containing the value 1.5.


{=INDEX($A:$F,SMALL(IF($E:$E<=$AF$1,ROW($A:$A)),ROW(1:1)),1)}