INDEX MATCH MATCH working great and then failing on me.

I have an INDEX MATCH MATCH formula working great, pulling data from a pivot table in one tab to table I created that is set up the same way. I am doing this several times in a workbook with similar sets of data, same formula.

However, in three of the tables, the last few rows ( between 1- 4) aren't pulling through and I am getting "0" when it should be pulling through a value. No idea why the formula works fine up until the end sometimes.

Any Ideas?

Here is my formula.
=INDEX('1Q10_Pivottable'!$B$5:$AM$162,MATCH($C112,'1Q10_Pivottable'!$A$5:$A$163),MATCH(I$6,'1Q10_Pivottable'!$B$4:$AM$4))

My index range is capturing all of the data. This is happening for larger and smaller datasets.

Thanks!

Hi,
I think your data is not placed in ascending order--> error!
Try this:

=INDEX('1Q10_Pivottable'!$B$5:$AM$162,MATCH($C112,'1Q10_Pivottable'!$A$5:$A$163,0),MATCH(I$6,'1Q10_Pivottable'!$B$4:$AM$4,0))

Thanks, this worked right away!
Having a similar issue elsewhere in the workbook. Not filling in values for last few rows but working fine all the time besides that. This time only one match criteria. I'm pulling a column of values together based on one criteria.

=IFERROR(INDEX('3Q10_LatLength'!$G$2:$G$155,MATCH(C141,'3Q10_LatLength'!$C$2:C$155,0)),)

Any ideas?