Simple Lookup Help

I am trying to return a "1" or "0" in a field by looking is a row for the word No. I have a few rows with multiple text words and I want to look in each row and if I see the word "No", I want to return the value 1. If I do not see the word "No", I want to return the value 0. As you can see in the attached, sometimes it works and sometimes it doesn't. Also, when I change the "No" value in row one, the output in column L turns to N/A.

How do I do this and why am I getting errors?

The lookup function requires the range to be sorted ascending, with it is not.

Try

=--ISNUMBER(MATCH("No",A1:J1,0))

Awesome, thanks.

A possible solution, although not exactly pretty could be to combine the IF and the OR function. For instance:

=IF(OR(A1="No",B1="no",C1="no",D1="no",E1="no",F1="no",G1="no",H1="no",I1="no",J1="no"),1,0)

Then copy down.