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.

Animal	Color		Animal	Has Black?
dog	brown		dog	Yes
dog	brown
dog	black
cat	white
cat	white
cat	black

<colgroup><col width="64" span="5" style="width:48pt"> </colgroup><tbody>
</tbody>

 

[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