How to identify a row number considering category my values falls into

[TheNotSoGoodExcelGuy]

Hello.

I have a value of X (let's say it's 1000).

I want to identify a row that X falls into between the two values of columns A and B, for example

ROW   Column A       Column B

1         Min length      Max length

2          800                  900

3          901                 1000

4          1001               1100

How can I do this? I have a lot of data such as this. My example is just a very simplified version of it.

[#2]

@TheNotSoGoodExcelGuy 

=MATCH(1,(D2>=$A$2:$A$4)*(D2<=$B$2:$B$4),0)+1

You can try this formula if you want to return the row number. Enter the formula with ctrl+shift+enter if you don't work with Office365 or Excel 2021.