Searching & Matching

[Tuzisheng]

I am new to Excel and am having a hard time figuring out how to search
range for at least 1 example of a text string and having it return
value.

So here is what I am having happen. I have a ton of if statement
outputting into column C. Which give off 3 different values(Passed
Failed, ""). What I want is one formula in cell D1 to look at all o
the different values in column C and to output a value if at least
value in column C matches.


Can someone help me

 

[Leo Heuser]

Tuzisheng

One way:

If output value is e.g 8 then in D1:

=IF(COUNTIF(C2:C1000,"Passed"),8)

will return value, if at least one cell in
C2:C1000 contains the word "Passed"
(without quotes)