Index suddenly stopped working

IBRIEOG
IBRIEOG โœญโœญโœญโœญ

Hello,

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.

image.png

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

image.png

Any ideas on how to fix?

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!