Index(Match) Issue being annoying/dumb

jamesmev

Board Regular
Joined
Apr 9, 2015
Messages
136
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
 

Some videos you may like

Excel Facts

How can you turn a range sideways?
Copy the range. Select a blank cell. Right-click, Paste Special, then choose Transpose.

jamesmev

Board Regular
Joined
Apr 9, 2015
Messages
136
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.
 

Watch MrExcel Video

Forum statistics

Threads
1,095,697
Messages
5,446,006
Members
405,377
Latest member
joaofigu78

This Week's Hot Topics

Top