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


Was this post helpful to you?

Why should I rate a post?

formula with multiple worksheets
 

I replied (for the third time!) to your posting "Need formula - Any ideas****
" on 13th March with a solution which works using your data.

=VLOOKUP($C$1,Sheet2!$A$2:$E$5,2,0) Payroll for 03/04 (in Column B)

=VLOOKUP($C$1,Sheet2!$A$2:$E$5,3,0) Premium for 03/04 (In Column C)

=VLOOKUP($C$1,Sheet2!$A$2:$E$5,5,0) Fixed Cost for 03/04 (in Column D)

Change Shett2 in the above to Sheet3 for 04/05. And Change ranges to reflet
number of rows in Sheets2 and 3.

Is this too diificult?

PLEASE look at the HELP for VLOOKUP as you seem unwilling to understand the
basics of this function and adjusting any solutions to meet your CHANGING
data layouts.



"walkerT" wrote:

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


Was this post helpful to you?

Why should I rate a post?

formula with multiple worksheets
 

See also one response to your multi-post in .newusers
Please do not multi-post ..

--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---

formula with multiple worksheets
 

You can do this very simply using the VLOOKUP function. Unfortunately as
your data layout is not clear I cannot give you the exact formula. If you
can improve the column alignment of your example I can help you with this.


If you are familiar with VLOOKUP, naming your data range on sheet 2 as 03_04
and on sheet 3 as 04_05 then the formula in sheet1!b4 would read:

=VLOOKUP(C1,03_04,2)

in sheet1!c4 it would be:

=VLOOKUP(C1,03_04,3)

and so forth