slab formula from to

[sachin483]

how to arrive slab from formula for from to condition as

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

<tbody>
</tbody>

 

[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