Check if value matches in a range

[suzeet]

Hi,
I want to match the column on a range. Suppose as in the example below, for the Sq No 1, if the Address column of first four rows (where Sq No = 1), I want to put a "YES" if matched, in the Match column

[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD]Sq No[/TD]
[TD]ID[/TD]
[TD]Address[/TD]
[TD]Match[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD="align: center"]1500946[/TD]
[TD][TABLE="width: 308"]
<tbody>[TR]
[TD="class: xl65, width: 308"]3410 WORTH ST[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD]YES[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]1500946[/TD]
[TD][TABLE="width: 308"]
<tbody>[TR]
[TD="class: xl65, width: 308"]3500 GASTON AVE[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]1500946[/TD]
[TD][TABLE="width: 308"]
<tbody>[TR]
[TD="class: xl65, width: 308"]6401 MAPLE AVE APT 1203[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD][TABLE="width: 64"]
<tbody>[TR]
[TD="class: xl65, width: 64, align: right"]3312005[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 308"]
<tbody>[TR]
[TD="class: xl65, width: 308"]3410 WORTH ST[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD]YES[/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD]590851[/TD]
[TD][TABLE="width: 308"]
<tbody>[TR]
[TD="class: xl65, width: 308"]3410 WORTH ST[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD]590851[/TD]
[TD][TABLE="width: 308"]
<tbody>[TR]
[TD="class: xl65, width: 308"]530 CLARA BARTON BLVD[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD][TABLE="width: 64"]
<tbody>[TR]
[TD="class: xl65, width: 64, align: right"]590851[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 308"]
<tbody>[TR]
[TD="class: xl65, width: 308"]TOPA[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD][TABLE="width: 64"]
<tbody>[TR]
[TD="class: xl65, width: 64, align: right"]3312027[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 308"]
<tbody>[TR]
[TD="class: xl65, width: 308"]3415 WORTH ST[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]3[/TD]
[TD][TABLE="width: 64"]
<tbody>[TR]
[TD="class: xl65, width: 64, align: right"]1469183[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 308"]
<tbody>[TR]
[TD="class: xl65, width: 308"]144 PINE MEADOWS LN[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD]YES[/TD]
[/TR]
[TR]
[TD]3[/TD]
[TD][TABLE="width: 64"]
<tbody>[TR]
[TD="class: xl65, width: 64, align: right"]3312034[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 308"]
<tbody>[TR]
[TD="class: xl65, width: 308"]144 PINE MEADOWS LN[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD]YES[/TD]
[/TR]
</tbody>[/TABLE]

 

[Special-K99]

How about this?

=IF(COUNTIFS(A$1:A$10,A1,C$1:C$10,C1)=2,"YES","")

Works fine on your sample data

BUT

make sure you test it on lots of other data as I'm not sure it's totally correct.

But it does work on your data.