Combine two formulas
I need help combining the below formulas.
=IFERROR(IF(INDEX({Option Exception Master List Range 1}, MATCH(Account@row, {Option Exception Master List}, 0)) = "N", "Yes-Not Discretionary", ""), "Not on List").
=IFERROR(IF(INDEX({Option Exception Master List Range 1}, MATCH(Account@row, {Option Exception Master List}, 0)) = "A", "Yes-Discretionary", "").
Answers
-
Hi @C. Perry
Without being able to test this, its a freehand attempt but I placed the second formula where I would when stacking IF formulas.
Removed the IFERROR simply to clear it up initially which you can add back in if the attempt works...
=IF(INDEX({Option Exception Master List Range 1}, MATCH(Account@row, {Option Exception Master List}, 0)) = "N", "Yes-Not Discretionary", IF(INDEX({Option Exception Master List Range 1}, MATCH(Account@row, {Option Exception Master List}, 0)) = "A", "Yes-Discretionary", "")
Hope this helps
Thanks
Paul
-
When I add back the IFERROR I get
=IFERROR(IF(INDEX({Option Exception Master List Range 1}, MATCH(Account@row, {Option Exception Master List}, 0)) = "N", "Yes-Not Discretionary", IFERROR(IF(INDEX({Option Exception Master List Range 1}, MATCH(Account@row, {Option Exception Master List}, 0)) = "Y", "Yes-Discretionary", ""))))
Your formula below works but if Account@row column is blank space I get "Yes-Discretionary" for a blank space. =IF(INDEX({Option Exception Master List Range 1}, MATCH(Account@row, {Option Exception Master List}, 0)) = "N", "Yes-Not Discretionary", IF(INDEX({Option Exception Master List Range 1}, MATCH(Account@row, {Option Exception Master List}, 0)) = "Y", "Yes-Discretionary", "")). Can the formula be enhanced to return a blank if Account@row is a blank cell?
-
Give this a try:
=IFERROR(IF(INDEX({Option Exception Master List Range 1}, MATCH(Account@row, {Option Exception Master List}, 0)) = "N", "Yes-Not Discretionary", IF(INDEX({Option Exception Master List Range 1}, MATCH(Account@row, {Option Exception Master List}, 0)) = "A", "Yes-Discretionary")), "Not on List")
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 65.2K Get Help
- 445 Global Discussions
- 143 Industry Talk
- 476 Announcements
- 5K Ideas & Feature Requests
- 84 Brandfolder
- 150 Just for fun
- 71 Community Job Board
- 488 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 301 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!