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?
|