How about
=IF(SUMPRODUCT(--($B$2:$B$7 = B2),--($A$2:$A$7 =
"cars"))+SUMPRODUCT(--($B$2:$B$7 = B2),--($A$2:$A$7 = "trucks"))=2,"Y","N")
--
Kevin Vaughn
"exceluser2" wrote:
Here is an example of the current sheet
Type | Site
cars | Automart.com
cars | MSN Autos
trucks| MSN Autos
food | kraft.com
trucks | fordtrucks.com
I would like to create a new collumn titled match. The function would
match if a site included both types (cars and trucks). Could I have
some help with this function?
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
--
exceluser2
------------------------------------------------------------------------
exceluser2's Profile: http://www.excelforum.com/member.php...o&userid=31338
View this thread: http://www.excelforum.com/showthread...hreadid=510203