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.
[TABLE="width: 169"]
<colgroup><col><col span="2"></colgroup><tbody>[TR]
[TD]Sl No.[/TD]
[TD]From[/TD]
[TD]To[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD] 25.00[/TD]
[TD]50.99[/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD] 51.00[/TD]
[TD]100.99[/TD]
[/TR]
[TR]
[TD]3[/TD]
[TD] 101.00[/TD]
[TD]200.99[/TD]
[/TR]
[TR]
[TD]4[/TD]
[TD] 201.00[/TD]
[TD]300.99[/TD]
[/TR]
[TR]
[TD]5[/TD]
[TD] 301.00[/TD]
[TD]400.99[/TD]
[/TR]
[TR]
[TD]6[/TD]
[TD] 401.00[/TD]
[TD]500.99[/TD]
[/TR]
</tbody>[/TABLE]
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.
[TABLE="width: 169"]
<colgroup><col><col span="2"></colgroup><tbody>[TR]
[TD]Sl No.[/TD]
[TD]From[/TD]
[TD]To[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD] 25.00[/TD]
[TD]50.99[/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD] 51.00[/TD]
[TD]100.99[/TD]
[/TR]
[TR]
[TD]3[/TD]
[TD] 101.00[/TD]
[TD]200.99[/TD]
[/TR]
[TR]
[TD]4[/TD]
[TD] 201.00[/TD]
[TD]300.99[/TD]
[/TR]
[TR]
[TD]5[/TD]
[TD] 301.00[/TD]
[TD]400.99[/TD]
[/TR]
[TR]
[TD]6[/TD]
[TD] 401.00[/TD]
[TD]500.99[/TD]
[/TR]
</tbody>[/TABLE]