Index suddenly stopped working
Wondering if anyone has experienced this before and can provide some guidance.
I have a sheet which uses index match in column formulas to pull data from multiple other sheets. This sheet has been working perfectly for several years and has not been edited.
This morning, every index match formula is giving an #error.
Version history shows the errors appeared at the same time on 3 May 2022.
I have closed and reopened, checked that the source data is ok, checked other sheets with similar functionality and this appears to be the only sheet with issues.
I think is has something to do with the index function as the formula works when I take it back to the match only part of the formula
Any ideas on how to fix?
Help Article Resources
Check out the Formula Handbook template!