VLOOKUP range and IF?

[Matt]

Data setup:
A: ID # B: Place
1 33133 C
2 33133 C
3 33133 Y
4 44144 C
5 44144 C

And so forth.

The need: a combination VLOOKUP and IF formula that will fill in the
following:

A: ID # B: At Least One Non-C
1 33133 Yes
2 44144 No

Any thoughts?

 

[Bob Phillips]

=SUMPRODUCT(--('Data setup'!$A$A:$A$200=A2),--('Data
setup'!$B$2:$B$200<>"C"))>0

 

[Bob Phillips]

=SUMPRODUCT(--('Data setup'!$A$2:$A$200=A2),--('Data
setup'!$B$2:$B$20<>"C"))>0

 

[Matt]

Worked perfectly, Bob - thanks.

=SUMPRODUCT(--('Data setup'!$A$2:$A$200=A2),--('Data
setup'!$B$2:$B$20<>"C"))>0

--
__________________________________
HTH

Bob