Return the row number if value is between two values in excel

Question

If I have a lookup table with a range of number (Min and Max) in two columns. ON the second sheet, it contains the numbers (1-100). And I'd like to lookup the row number from the lookup table. How can I do?

Answer 1

Consider:

=INDEX(A$2:A$11,MATCH(D2,B$2:B$11,1))