| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
how do i get Data from another sheet
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. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Printing data validation scenarios | Excel Worksheet Functions | |||
| Does excel recognise names rather than cells? | Excel Worksheet Functions | |||
| Merger Two Data Sheet | Excel Discussion (Misc queries) | |||
| Copying multiple sheets from one book 2 another and undertake spec | Excel Discussion (Misc queries) | |||
| Function to automatically insert a new sheet as a result of data entry? | Excel Worksheet Functions | |||
Threaded Mode
