| 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. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
NEED FORMULA TO EXTRACT DATA
Assuming your - and = signs do not actually appear on Sheet1, try this
formula in Sheet2 cell D3 =VLOOKUP(C3,SHEET1!A:C,3,TRUE) Vaya con Dios, Chuck, CABGx3 "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. |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
NEED FORMULA TO EXTRACT DATA
Try...
=LOOKUP(Sheet2!C3,Sheet1!A1:A6,Sheet1!C1:C6) or =VLOOKUP(Sheet2!C3,Sheet1!A1:C6,3,TRUE) Hope this helps! In article , "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. |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
NEED FORMULA TO EXTRACT DATA
If you restructure your table like so:
1 50 10 51 100 20 101 150 25 151 200 30 201 250 45 251 300 60 You could use this formula: =VLOOKUP(C3,Sheet1!$A$10:$D$15,3,TRUE) -- Kevin Vaughn "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. |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
NEED FORMULA TO EXTRACT DATA
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. |
| Reply |
| 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 | |||
Linear Mode
