Page 1 of 2 1 2 LastLast
Results 1 to 10 of 15

Thread: Need HELP with my INDEX formula

  1. #1

    Need HELP with my INDEX formula



    Register for a FREE account, and/
    or Log in to avoid these ads!

    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
    Attached Files Attached Files

  2. #2
    Super Moderator NBVC's Avatar
    Join Date
    May 2011
    Location
    Mississauga, Canada
    Posts
    1,499
    Articles
    0
    Excel Version
    Excel 2016
    I am not sure that you need to use another "better" formula. That one you have is probably the best for this job.

    Are you sure that your Automatic calculations is turned on (in the Formulas Tab, Under Calculations Section)?


  3. #3
    Yes it is..

  4. #4
    Super Moderator NBVC's Avatar
    Join Date
    May 2011
    Location
    Mississauga, Canada
    Posts
    1,499
    Articles
    0
    Excel Version
    Excel 2016
    Well, unless then you are mixing somehow the formats and entering numbers as text, then I don't see why you would have that problem.

    What exactly do you mean by "stopped working"? Is the result wrong, is it giving an error? is it simply not changing the value upon change in parameters?


  5. #5
    it gives a 1 or a 0 as a result. Which is very odd.

  6. #6
    Super Moderator NBVC's Avatar
    Join Date
    May 2011
    Location
    Mississauga, Canada
    Posts
    1,499
    Articles
    0
    Excel Version
    Excel 2016
    I can see maybe getting a 0, but not a 1. Is it happening to you right now? Are you able to show a current instance of the problem occurring?


  7. #7
    All formats are numbers btw I double checked

  8. #8
    Here you have the attachment with a full time line.

    The problem occurs after calenderweek 16. If you switch it to 17 and beyond the numbers get odd
    Attached Files Attached Files
    Last edited by EmileEA; 2014-06-26 at 02:08 PM.

  9. #9
    Super Moderator NBVC's Avatar
    Join Date
    May 2011
    Location
    Mississauga, Canada
    Posts
    1,499
    Articles
    0
    Excel Version
    Excel 2016
    Click Go Advance under the Quick Reply box. Then hit the paperclip icon and do as you did in your first post.


  10. #10

Page 1 of 2 1 2 LastLast

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •