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