If you restructure your table like so:
1 50 10
51 100 20
101 150 25
151 200 30
201 250 45
251 300 60

You could use this formula:

=VLOOKUP(C3,Sheet1!$A$10:$D$15,3,TRUE)

--
Kevin Vaughn


"Kulin Shah" wrote:

> On Sheet1 i have the below Data:
>
> A1 B1 C1
> 01 - 50 = 10
> 51 - 100 = 20
> 101 - 150 = 25
> 151 - 200 = 30
> 201 - 250 = 45
> 251 - 300 = 60
> so on...
>
> On Sheet2 for eg on Cell C3 i have a total on 222, i would Cell D3 to pick
> up "45" from Sheet1.
>
> Is this possible. Please suggest a solution for the same!
>
> Many Thanks,
>
>
>
> Kulin Shah.