Home

Formal question. IF vs index match

Highlighted
derick vanzuuk
Occasional Visitor

Formal question. IF vs index match

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 Replies

Re: Formal question. IF vs index match

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?

Re: Formal question. IF vs index match

I was thinking the same thing, it needs to be clarified as the requirement is conflicting!
Related Conversations
INDEX MATCH MATCH #N/A Error
Tanisha Perry-Warner in Formulas and Functions on
2 Replies
Add 5 if a cell contains text "yes"
Titchard Family in Formulas and Functions on
6 Replies
IFERROR - HLOOKUP- IF formula error
data24365 in Formulas and Functions on
14 Replies
Will Microsoft Stream work on mobile devices?
Sandy Rivas in Archived on
5 Replies
Call queue questions
SB V in Skype for Business IT Pro on
3 Replies
Sharepoint search
anonymous-user in Microsoft Stream Forum on
1 Replies