Finding a corresponding value for a number, in a number range table

[NSSKumar]

Hello there,

I have a range of numbers in different columns. Col A holds serial numbers (Sl No.), Col B holds From Number & Col C holds To Number. If i need to select the corresponding Sl No. for a number (say in this case it is 426.00) that falls between 401.00 & 500.99, how do i get that? I tried using index, match but excel needs to be told a range to pick it from, right? Many thanks for your help.

Sl No.	From	To
1	25.00	50.99
2	51.00	100.99
3	101.00	200.99
4	201.00	300.99
5	301.00	400.99
6	401.00	500.99

<colgroup><col><col span="2"></colgroup><tbody>
</tbody>

 

[njimack]

=index(a2:a7,match(426,b2:b7,1))

 

[NSSKumar]

Thank Neil. That was helpful.