Moving a Index/Match function

FraserKitchell · #1 01-18-2010, 04:23 PM

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

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
How do I create an index of every word in a document?	jbengal	Word	5	11-23-2022 02:17 PM
Problem with creating index	klb_08	Word	0	11-11-2009 06:08 AM
Match numbered list formatting b/w documents?	sbranecki	Word	0	09-10-2009 03:12 PM
Problems with Match	Theofficehedgehog	Excel	3	07-26-2009 02:07 PM
Need another formula to match my last one	tinkertron	Excel	2	04-29-2009 02:17 PM