Please correct formula,

[srizki]

I have several worksheets names listed in column B of consolidated worksheet, expenses in column H of consolidated worksheet and column heading in row 4. I want a formula that bring the values from corresponding sheets, by matching column A for sheet name, column H for expense type and row 4 for heading.
I tried to build the following formula that is not working,
'=INDEX(INDIRECT("'"&B25&"'!'115'!L5:Q11"),MATCH(G25,INDIRECT("'"&B25&"'!'115'!B5:B11"),0),MATCH(U4,INDIRECT("'"&B25&"'!4:4"),0))

Thanks

 

[Special-K99]

Best post a dummy spreadsheet.

 

[srizki]

A	B	C	D	E	F
	RC				RC NAME	T	U	V
Version	RC	General & Administrations	General/Oper	RC OWNER	RC NAME	Pipelines	Terminals	Gas Storage
2014B	015	General & Administrations	G & A		015 G & A DIRECT	0.00%	0.00%	0.00%
	115	General & Administrations	G & A		115 DIRECTOR'S CHARGES
	117	General & Administrations	G & A		117 ADMINISTRATION VACATION ACCRUAL
	120	General & Administrations	G & A		120 CORPORATE MGMT HOUSTON
	121	General & Administrations	G & A		121 Legal Department
	126	General & Administrations	G & A		126 OFFICE OF THE CHAIRMAN
	132	General & Administrations	G & A		132 HR Department
	137	General & Administrations	G & A		137 INVESTOR RELATIONS
	138	General & Administrations	G & A		138 CORPORATE DEVELOPMENT
	146	General & Administrations	G & A		146 FINANCE ADMINISTRATION

<colgroup><col width="64" style="width: 48pt;"><colgroup><col width="43" style="width: 32pt; mso-width-source: userset; mso-width-alt: 1572;"><colgroup><col width="195" style="width: 146pt; mso-width-source: userset; mso-width-alt: 7131;"><colgroup><col width="101" style="width: 76pt; mso-width-source: userset; mso-width-alt: 3693;"><colgroup><col width="16" style="width: 12pt; mso-width-source: userset; mso-width-alt: 585;"><colgroup><col width="260" style="width: 195pt; mso-width-source: userset; mso-width-alt: 9508;"><colgroup><col width="64" style="width: 48pt;" span="3"><tbody>
</tbody>

		2014 BUDGET UPDATE		2014 UPDATE
Responsibility Name	Expense	Pipelines	Terminals	Gas Storage	BES	BDL	GM	Corporate	Total		Pipelines	Terminals	Gas Storage	BES	BDL	GM	Corp.	Total
115 DIRECTOR'S CHARGES	PAYROLL REGULAR EXPENSE							100.0%	100.0%		34.5%	28.8%	2.0%	2.4%	4.2%	28.1%	-100%	0.0%
115 DIRECTOR'S CHARGES	PAYROLL CHARGED							100.0%	100.0%		34.5%	28.8%	2.0%	2.4%	4.2%	28.1%	-100%	0.0%
115 DIRECTOR'S CHARGES	TRAVEL EXPENSE							100.0%	100.0%		34.5%	28.8%	2.0%	2.4%	4.2%	28.1%	-100%	0.0%
115 DIRECTOR'S CHARGES	COMMUNICATION EXPENSE							100.0%	100.0%		34.5%	28.8%	2.0%	2.4%	4.2%	28.1%	-100%	0.0%
115 DIRECTOR'S CHARGES	OTHER CONTROLLABLE EXPENSE							100.0%	100.0%		34.5%	28.8%	2.0%	2.4%	4.2%	28.1%	-100%	0.0%
115 DIRECTOR'S CHARGES	PROFESSIONAL FEES EXPENSE							100.0%	100.0%		34.5%	28.8%	2.0%	2.4%	4.2%	28.1%	-100%	0.0%
115 DIRECTOR'S CHARGES	PAYROLL BENEFITS EXPENSE							100.0%	100.0%		34.5%	28.8%	2.0%	2.4%	4.2%	28.1%	-100%	0.0%
115 DIRECTOR'S CHARGES	Expenses

<colgroup><col width="185" style="width: 139pt; mso-width-source: userset; mso-width-alt: 6765;"> <col width="208" style="width: 156pt; mso-width-source: userset; mso-width-alt: 7606;"> <col width="60" style="width: 45pt; mso-width-source: userset; mso-width-alt: 2194;" span="8"> <col width="6" style="width: 5pt; mso-width-source: userset; mso-width-alt: 219;"> <col width="76" style="width: 57pt; mso-width-source: userset; mso-width-alt: 2779;"> <col width="60" style="width: 45pt; mso-width-source: userset; mso-width-alt: 2194;" span="7"> <tbody> </tbody>

 

[srizki]

I have found the answer.
=INDEX(INDIRECT("'"&B94&"'!L1:L35"),MATCH(G94,INDIRECT("'"&B94&"'!B1:B35"),0),MATCH(AC4,INDIRECT("'"&B94&"'!L4:R4"),0))

But the problem is how can I drag this to other cells?