Results 1 to 4 of 4

Thread: Index(Match) Issue being annoying/dumb
Thanks Thanks: 0 Likes Likes: 0

  1. #1
    Board Regular
    Join Date
    Apr 2015
    Posts
    126
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Index(Match) Issue being annoying/dumb

    I am using index match to fill in a form from data on a closed workbook. It works perfectly 99% of the time.
    However, it starts retrieving wrong data out of no where. Nothing changed with the formula. Just out of the blue it decides it will not pull the correct information.
    If I open the closed workbook all the data is correct again on my index.

    Not sure why this happens or how to fix it.
    This JUST started happening and I've used this method for years

  2. #2
    Board Regular
    Join Date
    Apr 2015
    Posts
    126
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Index(Match) Issue being annoying/dumb

    Quote Originally Posted by jamesmev View Post
    I am using index match to fill in a form from data on a closed workbook. It works perfectly 99% of the time.
    However, it starts retrieving wrong data out of no where. Nothing changed with the formula. Just out of the blue it decides it will not pull the correct information.
    If I open the closed workbook all the data is correct again on my index.

    Not sure why this happens or how to fix it.
    This JUST started happening and I've used this method for years
    ya I don't get it.

  3. #3
    Board Regular
    Join Date
    Apr 2015
    Posts
    126
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Index(Match) Issue being annoying/dumb

    It appears we all are stumped.
    Quote Originally Posted by jamesmev View Post
    ya I don't get it.

  4. #4
    Board Regular Dr. Demento's Avatar
    Join Date
    Nov 2010
    Location
    Skipping stones off Charon's Ferry
    Posts
    534
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Index(Match) Issue being annoying/dumb

    Sounds like a refresh problem.

    Does this address it?
    https://support.office.com/en-us/art...E-B9C8AC058D35

Some videos you may like

User Tag List

Tags for this Thread

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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