One way:

=IF(ISNA(MATCH(A3,Sheet2!A1:A10000,1)),"No","Yes")



In article ,
"Greg" wrote:

Hi all,
I am trying to get thiscode to work a little better, it is doing what I
want, but I need it to give me a yes - no answer. It does give me the yes
answer but when it is not true it gives the #N/A symbol. How can I get the
code below just to put no instead of this.

=IF(MATCH(A3,Sheet2!A1:A10000,1),"YES","NO")

Thanks

Greg