INDEX/MATCH returning #NO MATCH error but only for ONE cell

I have the following formula checking for matching emails in two sheets & returning the date:

=IF(Done@row = 1, INDEX({Submission Date}, MATCH([Email Address]@row, {Submission Email})), "")

It's inside an IF statement because the Done column checks if there's a submission for the email in the first place--I only want the date if there has been a submission by that person. Just in case the issue is somehow related to that, here's that formula too:

=IF(CONTAINS([Email Address]@row, {Submission Email}), 1, 0)

It's working perfectly for dozens of cells, but for some reason this one email address is returning the #NO MATCH error & I have no idea why. I've tried copy/pasting the same exact string from one sheet to the other. I've tried deleting entirely & retyping. I'm still getting the #NO MATCH error every single time, but only for this one person & I have no clue how to fix it--the formula is working great for everyone else!!

For obvious reasons, I can't share the exact email address here. But I will point out that there is absolutely nothing special about it. It's set up the same as everyone else's: No special characters, no different format, just a standard issue email address set up the same as everyone else's. Also yes, the Submission Date has a date in it. All columns are fully filled out.

This is driving me absolutely insane because there doesn't seem to be any logic in why this particular email is giving me an error. Please help so I can return to sanity.

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!