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

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

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

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