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?
Answers
-
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)))))
-
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
bassam.khalil2009@gmail.com
☑️ Are you satisfied with my answer to your question? Please help the Community by marking it as an ( Accepted Answer), and I will be grateful for your "Vote Up" or "Insightful"
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.7K Get Help
- 433 Global Discussions
- 136 Industry Talk
- 468 Announcements
- 4.9K Ideas & Feature Requests
- 143 Brandfolder
- 147 Just for fun
- 64 Community Job Board
- 466 Show & Tell
- 32 Member Spotlight
- 2 SmartStories
- 298 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!