Zend certified PHP/Magento developer

Excel formula to selectively search a column based on another column?

How would I create this formula to be applied to Column C (returning a boolean)?

If B2 contains “apple”, see if the number in A2 exists in any other A cells whose row doesn’t contain “apple” in the B column. (Assuming other rows also have “apple” in the B column and may or may not have a duplicate number in the A column).