Hi all,

I was using an index formula for a few weeks for 7 different products (all seperated excel files).

Now after a few weeks using the index formula it stopped working for one product. 3 weeks later for another one and now this week again.

I have no clue why it randomly stops working after a few weeks. The week it stops varies for every product some I have already managed for 30 weeks and then stopped, for the other file it stopped after 8 weeks.

It costs me a lot of time to do it manually and therefore I need your help.

I'm using this formula

I made an attachment excel file for more specific details.

Could anyone give me a likewise formula so I can retrieve the same data?

I would be very very very very very thankfull!

Thanks

I was using an index formula for a few weeks for 7 different products (all seperated excel files).

Now after a few weeks using the index formula it stopped working for one product. 3 weeks later for another one and now this week again.

I have no clue why it randomly stops working after a few weeks. The week it stops varies for every product some I have already managed for 30 weeks and then stopped, for the other file it stopped after 8 weeks.

It costs me a lot of time to do it manually and therefore I need your help.

I'm using this formula

**=IFERROR(ROUNDUP(INDEX(Input!17:18;$G$7;MATCH($D$2;Input!$4:$4;0)-1);0);0)**I made an attachment excel file for more specific details.

Could anyone give me a likewise formula so I can retrieve the same data?

I would be very very very very very thankfull!

Thanks