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
=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
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