Can I change the result of a formula to be blank instead of "#NO MATCH"?

Judith Campf
Judith Campf ✭✭✭✭
edited 07/06/23 in Formulas and Functions

I have a formula that is working as expected - pulling names when it finds them in another sheet - and when the name is not there, the result is "#NO MATCH". I understand the "#NO MATCH" response, but I'm wondering if there is a way for the result to show as blank rather than the words "#NO MATCH". Below is the formula I am using:

=INDEX({23/24 Teacher Talk Attendance Range 1}, MATCH([Teacher Name]@row, {23/24 Teacher Talk Attendance Range 1}, 0))

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!