INDEX MATCH works then returns #NOMATCH upon saving the sheet.


OK, I'm really stuck on this one...

I've written a simple index match formula...

=INDEX({TSRCC}, MATCH([Unique Event+Session Date]@row, {TSR Event Name}, 0))

It worked perfectly fine. Then when I saved the sheet all rows changed to a #NOMATCH error.

When I rewrite the formula, it worked again, then when I went to save, it failed again #NOMATCH.

I'm so confused, any ideas?


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!