| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
NEED FORMULA TO EXTRACT DATA
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. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Getting all rows of data that have a value in a particular column | Excel Discussion (Misc queries) | |||
| ranking query | Excel Discussion (Misc queries) | |||
| Data compiling formula | Excel Worksheet Functions | |||
| Formula checking multiple worksheets | Excel Worksheet Functions | |||
| Formula checking multiple worksheets | Excel Worksheet Functions | |||
Threaded Mode
