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

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))

Find more posts tagged with

Accepted answers

Paul Newcome

You would use the same syntax that I have above. Just copy/paste your original formula (excluding the initial "=" symbol that indicates the start of a formula) into where I have "original_formula".

All comments

Paul Newcome

Yes. You would wrap the whole thing in an IFERROR statement.

=IFERROR(original_formula, "")

Judith Campf

Where does the error part go in the full formula? Can you type the full formula including the error part here?

Thank you, so much, Paul!

Paul Newcome

You would use the same syntax that I have above. Just copy/paste your original formula (excluding the initial "=" symbol that indicates the start of a formula) into where I have "original_formula".

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, latest, sort, sortType, lookupSort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.