Formal question. IF vs index match

[derick vanzuuk]

Based on what is below. I need a formula so that if there is a NO in any of the rows b1:I1, A2= B2+(row with no). In the example A2= Yellow,Goat. I would be satisfied with 2 formulas. One that if there is a NO in the row a1=yellow. Also if there is a NO in a row a1=Goat

	A	B	C	D	E	F	G	I
1			dog	cat	mouse	horse	ant	goat
2	=	Yellow	Yes	yes	#N/A	#N/A	#N/A	No

[#2]

would uou mind editing your question to clarify the row numbers.
"I need a formula so that if there is a NO in any of the rows b1:I1" Row 1?
" One that if there is a NO in the row a1=yellow. Also if there is a NO in a row a1=Goat" Both in A1?

[#3]

I was thinking the same thing, it needs to be clarified as the requirement is conflicting!