Thanks a lot got the solution.

Kulin.

"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.