Formula Help: If then (Match)

[rentonhighlands]

Members:
Please help me write a formula

Sample Data
A B
[TABLE="width: 128"]
<colgroup><col width="64" span="2" style="width:48pt"> </colgroup><tbody>[TR]
[TD="width: 64"]1.1.1.1[/TD]
[TD="width: 64"]1_V[/TD]
[/TR]
[TR]
[TD]1.1.1.1[/TD]
[TD]2_V[/TD]
[/TR]
[TR]
[TD]1.1.1.2[/TD]
[TD]1_V[/TD]
[/TR]
[TR]
[TD]1.1.1.3[/TD]
[TD]1_V[/TD]
[/TR]
</tbody>[/TABLE]

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