Index(Match) Issue being annoying/dumb

[jamesmev]

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

 

[jamesmev]

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.

 

[jamesmev]

It appears we all are stumped.

ya I don't get it.

 

[Dr. Demento]

Sounds like a refresh problem.

Does this address it?
https://support.office.com/en-us/ar...workbook-EB189DE2-A420-41D2-851E-B9C8AC058D35