Help with code please
 

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

Help with code please
 

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

Help with code please
 

Thanks it works great just one other thing how can I make it be more
flexible. i.e. I have the person name in cell a10 and it put that code in
it is not going to look up the right person how can this be changed.

Sorry

Greg
"JE McGimpsey" wrote in message
...
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

Help with code please
 

Dont worry about it I am so slow sometimes, I worked it out

Thanks

Greg

"Greg" wrote in message
...
Thanks it works great just one other thing how can I make it be more
flexible. i.e. I have the person name in cell a10 and it put that code in
it is not going to look up the right person how can this be changed.

Sorry

Greg
"JE McGimpsey" wrote in message
...
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