Hi,

Please can someone help, I think im facing a similar problem.

If I pull the data using the SUMIF, it shows the correct results.

=SUMIF(dump!$A:$A,summary!$A3,dump!$B:$B)Book2.xls

But if I use the Index match, it returns '0' instead of 2.

=SUMIF(dump!$A:$A,summary!$A3,INDEX(dump!A2:D2,0,MATCH(summary!B2,dump!B2:D2,0)))

I need to use the index match as my columns for months would keep changing, as well as the database.

Please help!