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

BullandKhmer · 01/30/22

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 · 01/31/22

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 · 02/02/22

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

Answers