i am working with excel 2003 pro.

on Sheet1 i have the database eg
01 - 50 = 10,
51 - 100 = 15
100 - 150 = 30
so on....

On sheet2 i have a cell where i want excel to pick up data from sheet1

eg Sheet2 Cell A1 has value 140.
i want Cell B3 to Pick up 30.

I have tried IF function, but it does not help.... Please suggest a solution.

I hope the above is understandable and in a good order.

Many Thanks,



Kulin Shah.