Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Formula with multiple worksheets
I have multiple worksheets and want to be able to type in a district name in
Cell C1-sheet 1 and have it pull the corresponding ISD infomration for payroll, Premium, and fixed cost for years 03-04 from sheet 2 into sheet1 for cells B5 for 03-04 payroll, C5 for 03-04 premiums, and D5 for 03-04 for fixed cost. Also need the formula to do the same thing for 04-05 in sheet 1 from sheet 3 Sheet 1 Cell A B C D 1 2 Payroll Normal Premium Fixed Cost 3 4 2003-04 5 2004-05 Sheet 2 Cell A B C D E 1 2 03 District 03 Payroll 03 NP 03 Max LF 03 Fixed Cost 3 AISD 230846 4999 2264 1200 4 BISD 25171 512 108143 29271 5 TISD 12913 3507 13022 821 Sheet 3 Cell A B C D E 1 2 04 District 04 Payroll 04 NP 04 Max LF 04 Fixed Cost 3 AISD 5555555 44444 33333 22224 4 BISD 25411 51287 10843 2971 5 TISD 174213 350 132 891 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Formula help for multiple worksheets | Excel Discussion (Misc queries) | |||
COUNTIF Formula in Multiple worksheets. | Excel Discussion (Misc queries) | |||
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 |