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!