Possible to have two IFERROR values?
I have an IFERROR formula that is working correctly., However, I was wondering if it was possible to add an additional IFERROR option. So, for instance, This formula works perfectly:
=IFERROR(INDEX({EventTitle}, MATCH([WE ID#]@row, {ID}, 0)), INDEX({EventTitleComp}, MATCH([WE ID#]@row, {IDComp}, 0)))
My only problem is that I was hoping to add an additional value of N/A, or even just blank, if the formula was still returning a #NO MATCH error. There are some WE ID#'s that are on my current sheet that will not be found on either sheet that the formulas are referencing.
So is it possible to add another option to the end? IE:
=IFERROR(INDEX({EventTitle}, MATCH([WE ID#]@row, {ID}, 0)), INDEX({EventTitleComp}, MATCH([WE ID#]@row, {IDComp}, 0)), "N/A")))
Thank you all for your help!
Best Answer

Sure you can. Just test for the first condition using your IFERROR, and then in the "value_if_error" portion of this first test, put your second test. And then wrap that second test in the IFERROR formula.
One way to accomplish this is to put the two formulas in two fields, with the IFERROR wrappers, and get them both working. Then copy the first working formula into the "value_if_error" portion of the second.
Answers

Sure you can. Just test for the first condition using your IFERROR, and then in the "value_if_error" portion of this first test, put your second test. And then wrap that second test in the IFERROR formula.
One way to accomplish this is to put the two formulas in two fields, with the IFERROR wrappers, and get them both working. Then copy the first working formula into the "value_if_error" portion of the second.

Hi James!! Thank you so much for your help!
This is the formula that worked for me, just in case anyone needs a visual:
=IFERROR(INDEX({EventTitle}, MATCH([WE ID#]@row, {ID}, 0)), IFERROR(INDEX({EventTitleComp}, MATCH([WE ID#]@row, {IDComp}, 0)), "N/A"))
Help Article Resources
Categories
 All Categories
 14 Welcome to the Community
 Smartsheet Customer Resources
 63K Get Help
 380 Global Discussions
 212 Industry Talk
 442 Announcements
 4.6K Ideas & Feature Requests
 140 Brandfolder
 129 Just for fun
 130 Community Job Board
 449 Show & Tell
 30 Member Spotlight
 1 SmartStories
 305 Events
 34 Webinars
 7.3K Forum Archives
Check out the Formula Handbook template!