Help with populating one column based on value of range of columns
I have a number of columns with either "High", "Medium" or "Low" as the value and am wanting to return either "Yes", "No" or "Maybe" in another column based a result in any of those columns.
So if any of columns A - E contains "High" then column F should show "Yes"
Thanks in advance for any help!
Best Answer
-
Hi @Kristen Beer
Hope you are fine, please try the following formula and convert it to column format formula:
=IFERROR(IF(COUNTIF(A@row:E@row, "High") > 0, "Yes", "No"), "")
the following screenshot shows the result:
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"
Answers
-
Hi @Kristen Beer
Hope you are fine, please try the following formula and convert it to column format formula:
=IFERROR(IF(COUNTIF(A@row:E@row, "High") > 0, "Yes", "No"), "")
the following screenshot shows the result:
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"
-
That worked perfectly - thank you very much!
-
Excellent, I will be happy to help you any time. I will appreciate your vote on this post.
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
- 66K Get Help
- 429 Global Discussions
- 147 Industry Talk
- 487 Announcements
- 5.2K Ideas & Feature Requests
- 86 Brandfolder
- 152 Just for fun
- 74 Community Job Board
- 497 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 305 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!