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