Index match doesn't work- please help

[jessicafang]

Good evening,

Could please someone help me with this index match formula, don't why it doesn't work.

		Jan-14	Feb-14	Mar-14	Apr-14	May-14	Jun-14	Jul-14	Aug-14	Sep-14	Oct-14
Feb-14	B2CNHH SEGMENTED VOLUME @ CT	=INDEX(C8:L81,MATCH(1,(B8:B81=B2)*(A8:A81=A2),0),MATCH(C1,C7:L7,0))
Feb-14	B2CCT VOLUME (SETTLEMENT ADJUSTMENT)
Feb-14	Total SVA Adjustment (Elec Only)
		Jan-14	Feb-14	Mar-14	Apr-14	May-14	Jun-14	Jul-14	Aug-14	Sep-14	Oct-14
Feb-14	B2CDOMESTIC GASUnbilled Adjustments	-1	0	0	0	0	0	0																		0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	#REF!	#REF!	#REF!	#REF!	#REF!	#REF!	#REF!
B2CDOMESTIC GASRevenue Completeness	-6	-6	-5	-4	-2	-2	-1																		0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	#REF!	#REF!	#REF!	#REF!	#REF!	#REF!	#REF!
B2CDOMESTIC GASFixed Sales Revenue	16	14	16	15	16	16	16																		0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	#REF!	#REF!	#REF!	#REF!	#REF!	#REF!	#REF!
B2CDOMESTIC GASSales Revenue	169	154	141	97	51	29	23																		0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	#REF!	#REF!	#REF!	#REF!	#REF!	#REF!	#REF!
B2CRESIDENTIAL ELECTRICITYUnbilled Adjustments	-1	0	0	0	0	0	0																		0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	#REF!	#REF!	#REF!	#REF!	#REF!	#REF!	#REF!
B2CRESIDENTIAL ELECTRICITYRevenue Completeness	-2	-2	-2	-2	-2	-2	-2																		0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	#REF!	#REF!	#REF!	#REF!	#REF!	#REF!	#REF!
B2CRESIDENTIAL ELECTRICITYFixed Sales Revenue	20	18	20	19	20	19	20																		0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	#REF!	#REF!	#REF!	#REF!	#REF!	#REF!	#REF!
B2CRESIDENTIAL ELECTRICITYSales Revenue	188	168	172	145	133	120	122																		0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	#REF!	#REF!	#REF!	#REF!	#REF!	#REF!	#REF!
B2CNHH SEGMENTED VOLUME @ CT	1571	1388	1420	1186	1066	944	951																		0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	#REF!	#REF!	#REF!	#REF!	#REF!	#REF!	#REF!
B2CCT VOLUME (SETTLEMENT ADJUSTMENT)	-18	0	0	0	0	0	0																		0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	#REF!	#REF!	#REF!	#REF!	#REF!	#REF!	#REF!
B2CDUOS VARIABLE COSTS (SETTLEMENT ADJ)	0	0	0	0	0	0	0																		0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	#REF!	#REF!	#REF!	#REF!	#REF!	#REF!	#REF!
B2CRESIDENTIAL ELECTRICITY CONTINGENCY FUND (SETTLEMENT ADJ)	0	0	0	0	0	0	0																		0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	#REF!	#REF!	#REF!	#REF!	#REF!	#REF!	#REF!
B2CRESIDENTIAL ELECTRICITY PERCENTAGE DD DISCOUNT (SETTLEMENT ADJ)	0	0	0	0	0	0	0																		0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	#REF!	#REF!	#REF!	#REF!	#REF!	#REF!	#REF!
B2CRESIDENTIAL ELECTRICITY REVENUE (SETTLEMENT ADJ)	-2.3	0.0	0.0	0.0	0.0	0.0	0.0																		-3	-3	-3	-3	-2	-2	-2	-2	-2	-3	-3	-4	-4	-3	-4	-3	-2	-2	-2	-2	-2	-3	-3	-4	#REF!	#REF!	#REF!	#REF!	#REF!	#REF!	#REF!
B2CREVENUE COMPLETENESS RESIDENTIAL ELECTRICITY PERCENTAGE DD DISCOUNT (SETTLEMENT ADJ)	0	0	0	0	0	0	0																		0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	#REF!	#REF!	#REF!	#REF!	#REF!	#REF!	#REF!
B2CREVENUE COMPLETENESS RESIDENTIAL ELECTRICITY REVENUE (SETTLEMENT ADJ)	0	0	0	0	0	0	0																		0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	#REF!	#REF!	#REF!	#REF!	#REF!	#REF!	#REF!
B2CREVENUE MODELLING RESIDENTIAL ELECTRICITY PERCENTAGE DD DISCOUNT (SETTLEMENT ADJ)	0	0	0	0	0	0	0																		0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	#REF!	#REF!	#REF!	#REF!	#REF!	#REF!	#REF!
B2CREVENUE MODELLING RESIDENTIAL ELECTRICITY REVENUE (SETTLEMENT ADJ)	0	0	0	0	0	0	0																		0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	#REF!	#REF!	#REF!	#REF!	#REF!	#REF!	#REF!
Total SVA Adjustment (Elec Only)	-2	0	0	0	0	0	0																		-4	-4	-3	-3	-3	-3	-3	-3	-3	-3	-3	-4	-4	-4	-4	-3	-3	-3	-3	-3	-3	-3	-4	-4	#REF!	#REF!	#REF!	#REF!	#REF!	#REF!	#REF!
B2CREVENUE MODELLING DOMESTIC GAS DIRECT DEBIT DISCOUNT
B2CREVENUE MODELLING DOMESTIC GAS DUAL FUEL DISCOUNT
B2CREVENUE MODELLING DOMESTIC GAS IGT PREMIUM
B2CREVENUE MODELLING DOMESTIC GAS STANDING CHARGE
B2CREVENUE MODELLING DOMESTIC GAS UNIT REVENUE
Rev Modlling Adjustment Gas
B2CREVENUE MODELLING RESIDENTIAL ELECTRICITY CORE PERCENTAGE DD DISCOUNT	0	0	0	0	0	0	0																		0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	#REF!	#REF!	#REF!	#REF!	#REF!	#REF!	#REF!
B2CREVENUE MODELLING RESIDENTIAL ELECTRICITY CORE REVENUE	0	0	0	0	0	0	0																		0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	#REF!	#REF!	#REF!	#REF!	#REF!	#REF!	#REF!
B2CREVENUE MODELLING RESIDENTIAL ELECTRICITY MITIGATED DISCOUNT PERCENTAGE DD DISCOUNT	0	0	0	0	0	0	0																		1614	1553	1410	1237	1120	1018	1025	1005	1068	1300	1473	1640	1666	1484	1601	1199	1105	982	950	982	1009	1187	1445	1592	#REF!	#REF!	#REF!	#REF!	#REF!	#REF!	#REF!
B2CREVENUE MODELLING RESIDENTIAL ELECTRICITY MITIGATED DISCOUNT REVENUE	0	0	0	0	0	0	0																		-6	-6	-5	-5	-4	-3	-3	-3	-3	-4	-5	-12	-16	-15	-17	-13	-12	-11	-17	-19	-20	-35	-44	-49	#REF!	#REF!	#REF!	#REF!	#REF!	#REF!	#REF!
B2CREVENUE MODELLING RESIDENTIAL ELECTRICITY PERCENTAGE DD DISCOUNT	0	0	0	0	0	0	0																		0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	-1	-1	-1	#REF!	#REF!	#REF!	#REF!	#REF!	#REF!	#REF!
B2CREVENUE MODELLING RESIDENTIAL ELECTRICITY PERCENTAGE DD DISCOUNT (SETTLEMENT ADJ)	0	0	0	0	0	0	0																		0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	#REF!	#REF!	#REF!	#REF!	#REF!	#REF!	#REF!
B2CREVENUE MODELLING RESIDENTIAL ELECTRICITY RATE DD DISCOUNT	0	0	0	0	0	0	0																		0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	#REF!	#REF!	#REF!	#REF!	#REF!	#REF!	#REF!
B2CREVENUE MODELLING RESIDENTIAL ELECTRICITY REVENUE	-4	-3	-3	-3	-2	-2	-2																		-1	-1	-1	-1	0	0	0	0	0	-1	-1	-1	-2	-2	-2	-2	-2	-1	-2	-2	-3	-4	-5	-6	#REF!	#REF!	#REF!	#REF!	#REF!	#REF!	#REF!
B2CREVENUE MODELLING RESIDENTIAL ELECTRICITY REVENUE (SETTLEMENT ADJ)	0	0	0	0	0	0	0																		0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	#REF!	#REF!	#REF!	#REF!	#REF!	#REF!	#REF!
B2CREVENUE MODELLING RESIDENTIAL ELECTRICITY STANDING CHARGES REVENUE	0	0	0	0	0	0	0																		0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	#REF!	#REF!	#REF!	#REF!	#REF!	#REF!	#REF!
Rev Modlling Adjustment Elec	-4	-3	-4	-3	-3	-3	-3																		1607	1546	1404	1231	1116	1014	1021	1002	1064	1295	1467	1626	1647	1468	1582	1185	1091	969	930	960	986	1147	1395	1537	#REF!	#REF!	#REF!	#REF!	#REF!	#REF!	#REF!
2015	2016																																																	#REF!	#REF!	#REF!	#REF!	#REF!	#REF!	#REF!
Mar-14	B2CDOMESTIC GASUnbilled Adjustments	-1	0	0	0	0	0	0																		0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	#REF!	#REF!	#REF!	#REF!	#REF!	#REF!	#REF!
B2CDOMESTIC GASRevenue Completeness	-6	-6	-5	-4	-2	-2	-1																		0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	#REF!	#REF!	#REF!	#REF!	#REF!	#REF!	#REF!
B2CDOMESTIC GASFixed Sales Revenue	16	14	16	16	16	16	16																		0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	#REF!	#REF!	#REF!	#REF!	#REF!	#REF!	#REF!
B2CDOMESTIC GASSales Revenue	169	150	139	98	52	29	23																		0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	#REF!	#REF!	#REF!	#REF!	#REF!	#REF!	#REF!
B2CRESIDENTIAL ELECTRICITYUnbilled Adjustments	-1	0	0	0	0	0	0																		0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	#REF!	#REF!	#REF!	#REF!	#REF!	#REF!	#REF!
B2CRESIDENTIAL ELECTRICITYRevenue Completeness	-2	-2	-2	-2	-2	-2	-2																		0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	#REF!	#REF!	#REF!	#REF!	#REF!	#REF!	#REF!
B2CRESIDENTIAL ELECTRICITYFixed Sales Revenue	20	18	20	19	20	19	20																		0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	#REF!	#REF!	#REF!	#REF!	#REF!	#REF!	#REF!
B2CRESIDENTIAL ELECTRICITYSales Revenue	187	164	168	145	133	119	121																		0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	#REF!	#REF!	#REF!	#REF!	#REF!	#REF!	#REF!
B2CNHH SEGMENTED VOLUME @ CT	1580	1367	1386	1179	1058	938	944																		0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	#REF!	#REF!	#REF!	#REF!	#REF!	#REF!	#REF!
B2CCT VOLUME (SETTLEMENT ADJUSTMENT)	-40	-11	0	0	0	0	0																		0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	#REF!	#REF!	#REF!	#REF!	#REF!	#REF!	#REF!
B2CDUOS VARIABLE COSTS (SETTLEMENT ADJ)	-1	0	0	0	0	0	0																		0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	#REF!	#REF!	#REF!	#REF!	#REF!	#REF!	#REF!
B2CRESIDENTIAL ELECTRICITY CONTINGENCY FUND (SETTLEMENT ADJ)	0	0	0	0	0	0	0																		0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	#REF!	#REF!	#REF!	#REF!	#REF!	#REF!	#REF!
B2CRESIDENTIAL ELECTRICITY PERCENTAGE DD DISCOUNT (SETTLEMENT ADJ)	0	0	0	0	0	0	0																		0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	#REF!	#REF!	#REF!	#REF!	#REF!	#REF!	#REF!
B2CRESIDENTIAL ELECTRICITY REVENUE (SETTLEMENT ADJ)	-5.0	-1.4	0.0	0.0	0.0	0.0	0.0																		0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	#REF!	#REF!	#REF!	#REF!	#REF!	#REF!	#REF!
B2CREVENUE COMPLETENESS RESIDENTIAL ELECTRICITY PERCENTAGE DD DISCOUNT (SETTLEMENT ADJ)	0	0	0	0	0	0	0																		-3	-3	-3	-3	-2	-2	-2	-2	-2	-3	-3	-4	-4	-3	-4	-3	-2	-2	-2	-2	-2	-3	-3	-4	#REF!	#REF!	#REF!	#REF!	#REF!	#REF!	#REF!
B2CREVENUE COMPLETENESS RESIDENTIAL ELECTRICITY REVENUE (SETTLEMENT ADJ)	0	0	0	0	0	0	0																		0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	#REF!	#REF!	#REF!	#REF!	#REF!	#REF!	#REF!
B2CREVENUE MODELLING RESIDENTIAL ELECTRICITY PERCENTAGE DD DISCOUNT (SETTLEMENT ADJ)	0	0	0	0	0	0	0																		0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	#REF!	#REF!	#REF!	#REF!	#REF!	#REF!	#REF!
B2CREVENUE MODELLING RESIDENTIAL ELECTRICITY REVENUE (SETTLEMENT ADJ)	0	0	0	0	0	0	0																		0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	#REF!	#REF!	#REF!	#REF!	#REF!	#REF!	#REF!
Total SVA Adjustment (Elec Only)	-4	-1	0	0	0	0	0																		-3	-3	-3	-3	-3	-2	-2	-2	-2	-3	-3	-4	-4	-3	-4	-3	-3	-2	-2	-2	-2	-3	-3	-4	#REF!	#REF!	#REF!	#REF!	#REF!	#REF!	#REF!
B2CREVENUE MODELLING DOMESTIC GAS DIRECT DEBIT DISCOUNT
B2CREVENUE MODELLING DOMESTIC GAS DUAL FUEL DISCOUNT
B2CREVENUE MODELLING DOMESTIC GAS IGT PREMIUM
B2CREVENUE MODELLING DOMESTIC GAS STANDING CHARGE
B2CREVENUE MODELLING DOMESTIC GAS UNIT REVENUE
Rev Modlling Adjustment Gas
B2CREVENUE MODELLING RESIDENTIAL ELECTRICITY CORE PERCENTAGE DD DISCOUNT	0	0	0	0	0	0	0																		0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	#REF!	#REF!	#REF!	#REF!	#REF!	#REF!	#REF!
B2CREVENUE MODELLING RESIDENTIAL ELECTRICITY CORE REVENUE	0	0	0	0	0	0	0																		0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	#REF!	#REF!	#REF!	#REF!	#REF!	#REF!	#REF!
B2CREVENUE MODELLING RESIDENTIAL ELECTRICITY MITIGATED DISCOUNT PERCENTAGE DD DISCOUNT	0	0	0	0	0	0	0																		0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	#REF!	#REF!	#REF!	#REF!	#REF!	#REF!	#REF!
B2CREVENUE MODELLING RESIDENTIAL ELECTRICITY MITIGATED DISCOUNT REVENUE	0	0	0	0	0	0	0																		1614	1553	1410	1237	1120	1018	1025	1005	1068	1300	1473	1637	1664	1484	1601	1199	1105	982	941	982	1009	1175	1441	1588	#REF!	#REF!	#REF!	#REF!	#REF!	#REF!	#REF!
B2CREVENUE MODELLING RESIDENTIAL ELECTRICITY PERCENTAGE DD DISCOUNT	0	0	0	0	0	0	0																		-6	-6	-5	-5	-4	-3	-3	-3	-3	-4	-5	-6	-12	-15	-17	-13	-12	-11	-11	-19	-20	-22	-40	-42	#REF!	#REF!	#REF!	#REF!	#REF!	#REF!	#REF!
B2CREVENUE MODELLING RESIDENTIAL ELECTRICITY PERCENTAGE DD DISCOUNT (SETTLEMENT ADJ)	0	0	0	0	0	0	0																		0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	-1	-1	#REF!	#REF!	#REF!	#REF!	#REF!	#REF!	#REF!
B2CREVENUE MODELLING RESIDENTIAL ELECTRICITY RATE DD DISCOUNT	0	0	0	0	0	0	0																		0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	#REF!	#REF!	#REF!	#REF!	#REF!	#REF!	#REF!
B2CREVENUE MODELLING RESIDENTIAL ELECTRICITY REVENUE	-4	-3	-3	-3	-2	-2	-2																		0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	#REF!	#REF!	#REF!	#REF!	#REF!	#REF!	#REF!
B2CREVENUE MODELLING RESIDENTIAL ELECTRICITY REVENUE (SETTLEMENT ADJ)	0	0	0	0	0	0	0																		-1	-1	-1	-1	0	0	0	0	0	-1	-1	-1	-2	-2	-2	-2	-2	-1	-1	-2	-3	-3	-5	-5	#REF!	#REF!	#REF!	#REF!	#REF!	#REF!	#REF!
B2CREVENUE MODELLING RESIDENTIAL ELECTRICITY STANDING CHARGES REVENUE	0	0	0	0	0	0	0																		0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	#REF!	#REF!	#REF!	#REF!	#REF!	#REF!	#REF!
Rev Modlling Adjustment Elec	-4	-3	-3	-3	-3	-3	-3																		1607	1546	1404	1231	1116	1014	1021	1002	1064	1295	1467	1630	1650	1468	1582	1185	1091	969	928	960	986	1149	1395	1540	#REF!	#REF!	#REF!	#REF!	#REF!	#REF!	#REF!

<colgroup><col><col><col><col span="54"></colgroup><tbody>
</tbody>

 

[Mackers]

Hi

So that we can help, please could you post a small sample of your data, an explanation of what you are trying to do along with your expected results.

If you want to include your current formula, typed out rather than not, please do so.

Note that the #REF! error is often as a result of a formula that references a range that was deleted. So for example if you make a formula =A2, then delete the A2 cell, your formula will change to =#REF! and return an error.

Thanks