View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Matt Matt is offline
external usenet poster
 
Posts: 516
Default 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?