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

BullandKhmer

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?

BullandKhmer

Update, I've gone back into the sheet today and the formula works as intended. Would love to know whats going on here.

Any ideas anyone?

hollyconradsmith

Hi @BullandKhmer,

Are either the source sheet or the indexing sheet very large and have lots of formula fields? It could simply be a performance issue.

I would recommend reporting the issue to Smartsheet support: https://help.smartsheet.com/contact?fts=contact&_ga=2.116897414.1232551637.1643642854-725436069.1627560110