| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Need help - Complicated formula using multiple worksheets
I need a fromula that will pull information based on multiple worksheets that
will recognize the ISD when I type in the ISD NAME. The key is form me to be able to type in the isd name and have it pull all this information Example Sheet 1 Cell C1 - Blank Cell A4 - 2003-04 (The phsyical school year) Just a discription of information Cell A5 - 2004-05 (The phsyical school year) Just a discription of information Cell B2 - Payroll (Total payroll for the year ) Just a discription of information Cell C2 - Premuim (Total for the year) Just a discription of information Cell D2 - Fixed Cost(Total for the year) Just a discription of information So I would need the answer for the 03-04 payroll to go in cell B4, 03-04 premium in cell C4, and the 03-04 foxed cost in cell D4 What I need a formula for to do is pull example: from the sheet 2 which is the year 03-04, the information for payroll and put it in cell B4 give me the payroll for that year, also in sheet 3 which is the year 04-05, pull the information for payroll and put it in cell B5 Sheet 2 A3 is the school district B3 IS THE PAYROLL C3 IS THE PREMIUM D4 IS THE FIXXED COST So I would need the answer for the 04-05 payroll to go in cell B5, 03-04 premium in cell C5, and the 03-04 foxed cost in cell D5 Sheet 3 will be the same as sheet 2 except for the year 04-05 A3 is the school district B3 IS THE PAYROLL C3 IS THE PREMIUM D4 IS THE FIXED COST In know this is complicated so any assitance is greatly appreciated |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Need help - Complicated formula using multiple worksheets
Isn't this the same question you asked earlier to which you received replies
(e.g VLOOKUP) My previous answer: =VLOOKUP(C1,Sheet2!A1:D100,2,0) will give 03 payroll =VLOOKUP(C1,Sheet2!A1:D100,3,0) will give 03 Premium =VLOOKUP(C1,Sheet2!A1:D100,4,0) will give 03 Fixed cost Change Sheet2 to Sheet3 for 04 results. Assuming C1 is business name. This is replaced by ISD NAME? "walkerT" wrote: I need a fromula that will pull information based on multiple worksheets that will recognize the ISD when I type in the ISD NAME. The key is form me to be able to type in the isd name and have it pull all this information Example Sheet 1 Cell C1 - Blank Cell A4 - 2003-04 (The phsyical school year) Just a discription of information Cell A5 - 2004-05 (The phsyical school year) Just a discription of information Cell B2 - Payroll (Total payroll for the year ) Just a discription of information Cell C2 - Premuim (Total for the year) Just a discription of information Cell D2 - Fixed Cost(Total for the year) Just a discription of information So I would need the answer for the 03-04 payroll to go in cell B4, 03-04 premium in cell C4, and the 03-04 foxed cost in cell D4 What I need a formula for to do is pull example: from the sheet 2 which is the year 03-04, the information for payroll and put it in cell B4 give me the payroll for that year, also in sheet 3 which is the year 04-05, pull the information for payroll and put it in cell B5 Sheet 2 A3 is the school district B3 IS THE PAYROLL C3 IS THE PREMIUM D4 IS THE FIXXED COST So I would need the answer for the 04-05 payroll to go in cell B5, 03-04 premium in cell C5, and the 03-04 foxed cost in cell D5 Sheet 3 will be the same as sheet 2 except for the year 04-05 A3 is the school district B3 IS THE PAYROLL C3 IS THE PREMIUM D4 IS THE FIXED COST In know this is complicated so any assitance is greatly appreciated |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Need help - Complicated formula using multiple worksheets
I tried using the formula and didnt have any luck.....
"Toppers" wrote: Isn't this the same question you asked earlier to which you received replies (e.g VLOOKUP) My previous answer: =VLOOKUP(C1,Sheet2!A1:D100,2,0) will give 03 payroll =VLOOKUP(C1,Sheet2!A1:D100,3,0) will give 03 Premium =VLOOKUP(C1,Sheet2!A1:D100,4,0) will give 03 Fixed cost Change Sheet2 to Sheet3 for 04 results. Assuming C1 is business name. This is replaced by ISD NAME? "walkerT" wrote: I need a fromula that will pull information based on multiple worksheets that will recognize the ISD when I type in the ISD NAME. The key is form me to be able to type in the isd name and have it pull all this information Example Sheet 1 Cell C1 - Blank Cell A4 - 2003-04 (The phsyical school year) Just a discription of information Cell A5 - 2004-05 (The phsyical school year) Just a discription of information Cell B2 - Payroll (Total payroll for the year ) Just a discription of information Cell C2 - Premuim (Total for the year) Just a discription of information Cell D2 - Fixed Cost(Total for the year) Just a discription of information So I would need the answer for the 03-04 payroll to go in cell B4, 03-04 premium in cell C4, and the 03-04 foxed cost in cell D4 What I need a formula for to do is pull example: from the sheet 2 which is the year 03-04, the information for payroll and put it in cell B4 give me the payroll for that year, also in sheet 3 which is the year 04-05, pull the information for payroll and put it in cell B5 Sheet 2 A3 is the school district B3 IS THE PAYROLL C3 IS THE PREMIUM D4 IS THE FIXXED COST So I would need the answer for the 04-05 payroll to go in cell B5, 03-04 premium in cell C5, and the 03-04 foxed cost in cell D5 Sheet 3 will be the same as sheet 2 except for the year 04-05 A3 is the school district B3 IS THE PAYROLL C3 IS THE PREMIUM D4 IS THE FIXED COST In know this is complicated so any assitance is greatly appreciated |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Need help - Complicated formula using multiple worksheets
I also tried explaining it in another way, subject is ANY IDEAS
"walkerT" wrote: I tried using the formula and didnt have any luck..... "Toppers" wrote: Isn't this the same question you asked earlier to which you received replies (e.g VLOOKUP) My previous answer: =VLOOKUP(C1,Sheet2!A1:D100,2,0) will give 03 payroll =VLOOKUP(C1,Sheet2!A1:D100,3,0) will give 03 Premium =VLOOKUP(C1,Sheet2!A1:D100,4,0) will give 03 Fixed cost Change Sheet2 to Sheet3 for 04 results. Assuming C1 is business name. This is replaced by ISD NAME? "walkerT" wrote: I need a fromula that will pull information based on multiple worksheets that will recognize the ISD when I type in the ISD NAME. The key is form me to be able to type in the isd name and have it pull all this information Example Sheet 1 Cell C1 - Blank Cell A4 - 2003-04 (The phsyical school year) Just a discription of information Cell A5 - 2004-05 (The phsyical school year) Just a discription of information Cell B2 - Payroll (Total payroll for the year ) Just a discription of information Cell C2 - Premuim (Total for the year) Just a discription of information Cell D2 - Fixed Cost(Total for the year) Just a discription of information So I would need the answer for the 03-04 payroll to go in cell B4, 03-04 premium in cell C4, and the 03-04 foxed cost in cell D4 What I need a formula for to do is pull example: from the sheet 2 which is the year 03-04, the information for payroll and put it in cell B4 give me the payroll for that year, also in sheet 3 which is the year 04-05, pull the information for payroll and put it in cell B5 Sheet 2 A3 is the school district B3 IS THE PAYROLL C3 IS THE PREMIUM D4 IS THE FIXXED COST So I would need the answer for the 04-05 payroll to go in cell B5, 03-04 premium in cell C5, and the 03-04 foxed cost in cell D5 Sheet 3 will be the same as sheet 2 except for the year 04-05 A3 is the school district B3 IS THE PAYROLL C3 IS THE PREMIUM D4 IS THE FIXED COST In know this is complicated so any assitance is greatly appreciated |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Formula help for multiple worksheets | Excel Discussion (Misc queries) | |||
| How can use a lookup formula through multiple worksheets? | Excel Worksheet Functions | |||
| Copying a formula to multiple worksheets | Excel Worksheet Functions | |||
| Help with LARGE formula with multiple worksheets | Excel Worksheet Functions | |||
| Formula checking multiple worksheets | Excel Worksheet Functions | |||
Linear Mode
