| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Need formula - Any ideas****
I want to be able to type in a ISD name in sheet 1 Cell C1 and have the
formula pull the payroll for the ISD I named in cell C1 from sheet 2 for 03-04 and have it put in cell B4 and from sheet 3 for the ISD I named for 04-05 payrolland have it in cell B5. And do the same for Normal Premium and Fixed cost SHEET 1 A B C D 1 2 Payroll Normal Premium Fixed Cost 3 4 2003-04 5 2004-05 SHEET 2 (03-04) A B C D ISD Payroll Premium Fixed Cost 1 AISD 2 MFISD 3 TISD 4 CISD SHEET 3 (04-05) A B C D ISD Payroll Premium Fixed Cost 1 AISD 2 MFISD 3 TISD 4 CISD |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Need formula - Any ideas****
See previous replies on same/very similar questions from you. Please don't
multi-post. "walkerT" wrote: I want to be able to type in a ISD name in sheet 1 Cell C1 and have the formula pull the payroll for the ISD I named in cell C1 from sheet 2 for 03-04 and have it put in cell B4 and from sheet 3 for the ISD I named for 04-05 payrolland have it in cell B5. And do the same for Normal Premium and Fixed cost SHEET 1 A B C D 1 2 Payroll Normal Premium Fixed Cost 3 4 2003-04 5 2004-05 SHEET 2 (03-04) A B C D ISD Payroll Premium Fixed Cost 1 AISD 2 MFISD 3 TISD 4 CISD SHEET 3 (04-05) A B C D ISD Payroll Premium Fixed Cost 1 AISD 2 MFISD 3 TISD 4 CISD |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Need formula - Any ideas****
I am trying to explain it better and make it clearer to undertsand what
fromula I need... "Toppers" wrote: See previous replies on same/very similar questions from you. Please don't multi-post. "walkerT" wrote: I want to be able to type in a ISD name in sheet 1 Cell C1 and have the formula pull the payroll for the ISD I named in cell C1 from sheet 2 for 03-04 and have it put in cell B4 and from sheet 3 for the ISD I named for 04-05 payrolland have it in cell B5. And do the same for Normal Premium and Fixed cost SHEET 1 A B C D 1 2 Payroll Normal Premium Fixed Cost 3 4 2003-04 5 2004-05 SHEET 2 (03-04) A B C D ISD Payroll Premium Fixed Cost 1 AISD 2 MFISD 3 TISD 4 CISD SHEET 3 (04-05) A B C D ISD Payroll Premium Fixed Cost 1 AISD 2 MFISD 3 TISD 4 CISD |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Need formula - Any ideas****
=VLOOKUP($C$1,Sheet2!$A$2:$D$5,2,0) Payroll for 03/04
=VLOOKUP($C$1,Sheet2!$A$2:$D$5,3,0) Premium for 03/04 etc Works fine for me! "walkerT" wrote: I want to be able to type in a ISD name in sheet 1 Cell C1 and have the formula pull the payroll for the ISD I named in cell C1 from sheet 2 for 03-04 and have it put in cell B4 and from sheet 3 for the ISD I named for 04-05 payrolland have it in cell B5. And do the same for Normal Premium and Fixed cost SHEET 1 A B C D 1 2 Payroll Normal Premium Fixed Cost 3 4 2003-04 5 2004-05 SHEET 2 (03-04) A B C D ISD Payroll Premium Fixed Cost 1 AISD 2 MFISD 3 TISD 4 CISD SHEET 3 (04-05) A B C D ISD Payroll Premium Fixed Cost 1 AISD 2 MFISD 3 TISD 4 CISD |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| ANY IDEAS FOR A FORMULA TO KEEP A TEAM BOWLING SCORE | Excel Discussion (Misc queries) | |||
| Out of Ideas, need help with Auto Fill | Excel Worksheet Functions | |||
| Any Ideas? | Excel Worksheet Functions | |||
| Any Ideas | Excel Discussion (Misc queries) | |||
| formula from Excel97 doesn't work in Excel2003,any ideas why? | Excel Worksheet Functions | |||
Hybrid Mode
