I have some data I need to have returned if it matches something else. The
data pictured below is in worksheet 2. In cell A2 of worksheet 1 is 153.
The returned value would be No because below is a Yes and a No. If there is
a No anywhere in this list, the result should be No. The result for 156
would be Yes because that is the only option in the data below. The result
for 203 would be No because it is listed regardless of whether or not there
is a Yes listed for that one.


153 Yes
156 Yes
153 No
153 No
201 No
156 Yes
203 No
203 Yes

I need the "No" as the result if it appears anywhere in the list to the item
I need to match. If there isn't a "No" in the list to the matching item,
then the result would be "Yes". I hope this makes sense. I'm using Excel
2003. Thank you.