Formula Help: If then (Match)

[rentonhighlands]

Members:
Please help me write a formula

Sample Data
A B

1.1.1.1	1_V
1.1.1.1	2_V
1.1.1.2	1_V
1.1.1.3	1_V

<colgroup><col width="64" span="2" style="width:48pt"> </colgroup><tbody>
</tbody>

If column A finds a match on IP address and column B has both 1_V & 2_V then say YES in column C otherwise NO
I want to find in column A if there is the same IP address and it has both 1_V and 2_V I want Yes

 

[Fluff]

You're welcome