IFERROR not working?

I'm having problems with IFERROR not working to remove an error.

I have this formula, which looks for a contact's information (First Last Name, OR E-mail address, or Nickname) - it looks for that information on 3 different columns. My problem is that if it doesn't find the information in any of the three columns, it shows #NO MATCH. And that NO MATCH is throwing off all my other formulas. I can't seem to work out the right IFERROR so that it would just be blank if it doesn't find what its looking for.

=IFERROR(INDEX({EmployeeCode}, MATCH([Contact 3]@row, {FirstLastName}, 0)), IFERROR(INDEX({EmployeeCode}, MATCH([Contact 3]@row, {KnownName}, 0)), INDEX({EmployeeCode}, MATCH([Contact 3]@row, {E-mailAddress}, 0))))

Can anyone see what I'm doing wrong?

Find more posts tagged with

Accepted answers

All comments

Dominique Rose Winther

Also, I tried adding IFERROR before the last INDEX( but then I got #INCORRECT ARGUMENT instead.

i.e. =IFERROR(INDEX({EmployeeCode}, MATCH([Contact 3]@row, {FirstLastName}, 0)), IFERROR(INDEX({EmployeeCode}, MATCH([Contact 3]@row, {KnownName}, 0)), IFERROR(INDEX({EmployeeCode}, MATCH([Contact 3]@row, {E-mailAddress}, 0)))))

Bassam Khalil

Hi @Dominique WINTHER

Hope you are fine, could you please add a copy of your sheets (after removing or replacing any sensitive information). in excel format and i will write the exact formula for you, please send it to my Email

bassam.k@mobilproject.it

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.