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!
Bookmarks