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!
Help Article Resources
Check out the Formula Handbook template!