I am trying to have an index/match formula that moves to a new array. I am having trouble getting the ROW part of the Index function to move on to a new row at an appropriate time. An example file is attached, because I am having trouble explaining this.

You will see that I have to move the row on the 10th of the month because the data for the 11th is stored in a newer row... Any ideas for how to get that index/match function to be a little smarter?

Good luck!

Thanks,
Fraser

Attached Files

Moving Index;Match.xls (59.0 KB, 19 views)