How to find rows that don't contain a certain value

[wlan]

Hi,

I have a range of data:

A B C
man1 table
man1 pencil
man1 phone
man2 table
man2 phone
man3 table
man3 pencil
man3 phone


As you see above, each man have some items. I would like to write in column C "NO" if that man doesn't have a pencil. How can I do this?

[Fotis1991]

Hi

Do you mean something like this? In C1 and copy down.

=IF(SUMPRODUCT(($A$1:$A$8=A1)*($B$1:$B$8="pencil"))=0,"NO","")