VLOOKUP range and IF?
 

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?

VLOOKUP range and IF?
 

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

--
__________________________________
HTH

Bob

"Matt" wrote in message
...
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?

VLOOKUP range and IF?
 

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

--
__________________________________
HTH

Bob

"Matt" wrote in message
...
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?

VLOOKUP range and IF?
 

Worked perfectly, Bob - thanks.

"Bob Phillips" wrote:

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

--
__________________________________
HTH

Bob

"Matt" wrote in message
...
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?