Then this should work copied down

=IF(AND(SUMPRODUCT(--($A$2:$A$200="cars"),--($B$2:$B$200=B2))0,SUMPRODUCT(--($A$2:$A$200="trucks"),--($B$2:$B$200=B2))0),"Yes","No")

--
Regards,

Peo Sjoblom

Portland, Oregon




"exceluser2" wrote
in message ...


In the site column, can the sites occur more than once per type of
vehicle,
meaning if there is one MSN Autos for cars and one for trucks, that
would
total 2 thus return yes?


Yes sites can occur more then once.

Example

Type | Site | Match
cars | Automart.com | N
cars | MSN Autos | Y
cars | ford.com | Y
trucks| MSN Autos | Y
food | kraft.com | N
trucks | ford.com | Y
cars | ford.com | Y
cars | ford.com | Y
cars | ford.com | Y
cars | Automart.com | N

Also Sites should be Y even if for types that are not cars and truck if
the above condition is true.

food | kraft.com | N
food | ford.com | Y
food | ford.com | Y
food | ford.com | Y
food | ford.com | Y
food | Automart.com | N

Thanks for the help but it is still not what I need.


--
exceluser2
------------------------------------------------------------------------
exceluser2's Profile:
http://www.excelforum.com/member.php...o&userid=31338
View this thread: http://www.excelforum.com/showthread...hreadid=510203