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?