slab formula from to

[sachin483]

how to arrive slab from formula for from to condition as

[TABLE="width: 470"]
<tbody>[TR]
[TD="align: center"]DATA[/TD]
[TD="align: center"]result[/TD]
[TD="align: center"]formula[/TD]
[TD="align: center"][/TD]
[TD="align: center"]FROM[/TD]
[TD="align: center"]TO[/TD]
[TD="align: center"]SLAB[/TD]
[/TR]
[TR]
[TD="align: center"]1160121[/TD]
[TD="align: center"]10 - 15 lacs[/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"]0[/TD]
[TD="align: center"]199999[/TD]
[TD="align: center"]< 2.00 lacs[/TD]
[/TR]
[TR]
[TD="align: center"]905440[/TD]
[TD="align: center"]9 - 10 lacs[/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"]200000[/TD]
[TD="align: center"]299999[/TD]
[TD="align: center"]2 - 3 lacs[/TD]
[/TR]
[TR]
[TD="align: center"]465325[/TD]
[TD="align: center"]4 - 5 lacs[/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"]300000[/TD]
[TD="align: center"]399999[/TD]
[TD="align: center"]3 - 4 lacs[/TD]
[/TR]
[TR]
[TD="align: center"]1089309[/TD]
[TD="align: center"]10 - 15 lacs[/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"]400000[/TD]
[TD="align: center"]499999[/TD]
[TD="align: center"]4 - 5 lacs[/TD]
[/TR]
[TR]
[TD="align: center"]532279[/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"]500000[/TD]
[TD="align: center"]599999[/TD]
[TD="align: center"]5 - 6 lacs[/TD]
[/TR]
[TR]
[TD="align: center"]706746[/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"]600000[/TD]
[TD="align: center"]699999[/TD]
[TD="align: center"]6 - 7 lacs[/TD]
[/TR]
[TR]
[TD="align: center"]837324[/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"]700000[/TD]
[TD="align: center"]799999[/TD]
[TD="align: center"]7 - 8 lacs[/TD]
[/TR]
[TR]
[TD="align: center"]827206[/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"]800000[/TD]
[TD="align: center"]899999[/TD]
[TD="align: center"]8 - 9 lacs[/TD]
[/TR]
[TR]
[TD="align: center"]1025632[/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"]900000[/TD]
[TD="align: center"]999999[/TD]
[TD="align: center"]9 - 10 lacs[/TD]
[/TR]
[TR]
[TD="align: center"]949099[/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"]1000000[/TD]
[TD="align: center"]1499999[/TD]
[TD="align: center"]10 - 15 lacs[/TD]
[/TR]
[TR]
[TD="align: center"]478030[/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"]1500000[/TD]
[TD="align: center"]99999999[/TD]
[TD="align: center"]> 15 lacs[/TD]
[/TR]
[TR]
[TD="align: center"]537652[/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[/TR]
[TR]
[TD="align: center"]553326[/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[/TR]
[TR]
[TD="align: center"]269355[/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[/TR]
[TR]
[TD="align: center"]828887[/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[/TR]
[TR]
[TD="align: center"]1138777[/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

 

[etaf]

you can use a vlookup

assuming the table is in column D,E & F

and the value to lookup is in A

=vlookup(a2, $D$1:$F$12,3,true)

 

[sachin483]

Thanks a lot