I want to write a formula that will do the following:

Search for a POS in column C in rows where ID=ID. If a POS is found, output "yes" in the haspos? column, otherwise output "no".

Here is what the data looks like:

A B C row ----------------------------- 1 | ID | hasPOS? | Result ----------------------------- 2 1 yes NEG 3 1 yes NEG 4 1 yes POS 5 2 yes NEG 6 2 yes POS 7 2 yes BLANK 8 2 yes BLANK 9 3 no NEG 10 3 no NEG

So for example, for ID = 1, the formula would search C2, C3 and C4 for a POS. If found it will output "yes" in B2, B3 and B4. Can this be done without resorting to VBA?

Any insight is appreciated. Thanks.