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

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

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

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