Find Text in Group

[tommiexboi]

Hello,

Need your quick help.
I'm trying to write a formula where from a group I can find if it has a text (specific/partial).
"Has Black?" is the result I want.

[TABLE="width: 320"]
<colgroup><col width="64" span="5" style="width:48pt"> </colgroup><tbody>[TR]
[TD="class: xl63, width: 64"]Animal[/TD]
[TD="class: xl63, width: 64"]Color[/TD]
[TD="width: 64"][/TD]
[TD="class: xl63, width: 64"]Animal[/TD]
[TD="class: xl63, width: 64"]Has Black?[/TD]
[/TR]
[TR]
[TD="class: xl63"]dog[/TD]
[TD="class: xl63"]brown[/TD]
[TD][/TD]
[TD="class: xl63"]dog[/TD]
[TD="class: xl63"]Yes[/TD]
[/TR]
[TR]
[TD="class: xl63"]dog[/TD]
[TD="class: xl63"]brown[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="class: xl63"]dog[/TD]
[TD="class: xl63"]black[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="class: xl63"]cat[/TD]
[TD="class: xl63"]white[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="class: xl63"]cat[/TD]
[TD="class: xl63"]white[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="class: xl63"]cat[/TD]
[TD="class: xl63"]black[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

 

[Fluff]

How about

Book1
	A	B	C	D	E
1	Animal	Color		Animal	Black
2	dog	brown		dog	yes
3	dog	brown
4	dog	black
5	cat	white
6	cat	white
7	cat	black
Data

Cell Formulas
Range	Formula
E2	=IF(ISNUMBER(MATCH(D2&"|"&E1,INDEX(A2:A7&"|"&B2:B7,0),0)),"yes","no")

 

[tommiexboi]

That worked great! Thank you!

 

[Peter_SSs]

Another option..

Excel Workbook
	A	B	C	D	E	F
1	Animal	Color		Animal	Color	Result
2	dog	brown		dog	Black	Yes
3	dog	brown
4	dog	black
5	cat	white
6	cat	white
7	cat	black
Find Text in Group