Friday, February 24, 2017

yogi_Return One Of Three Strings Depending On Content of Row

Google Spreadsheet   Post  #2122
Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     www.energyefficientbuild.com.   Feb-24-2017
question by Alex Lou:
https://productforums.google.com/forum/?utm_medium=email&utm_source=ba_notification#!topic/docs/IIwZ3GR-YMs;context-place=forum/docs
Return one of three strings depending on row content
I am attempting to get Google Sheets to return one of 3 strings depending on the content of a row.

Specifically, if Column C contains the word "Failed" then return String 1 regardless of the content of its row. However, if Column C does not contain the word "Failed" and any other cell in the row contains "Failed" then return String 2. If no cell in the row contains "Failed" then return String 3.


I have tried a number of things including REGEXMATCH and IF but no luck.

Any help would be appreciated!