how do i get Data from another sheet

[Kulin Shah]

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.

[Wobbles]

Try =Sheetname followed bty ! then cell ref
(eg if you require data from C3 on sheet 2 it would be =Sheet2!C3

although a simpler way is to type the equals sign then click on the sheet
tab (bottom of sheets then click on the cell - pressing enter finishes it

Hope this helps

"Kulin Shah" wrote:

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