G
Guest
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
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