About Us

Greg[_27_]

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

JE McGimpsey

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

Greg[_27_]

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

Greg[_27_]

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

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Hybrid Mode Switch to Threaded Mode

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
split post code (zip code) out of cell that includes full address	Concord	Excel Discussion (Misc queries)	4	October 15th 09 06:59 PM
Drop Down/List w/Code and Definition, only code entered when selec	Spiritdancer	Excel Worksheet Functions	2	November 2nd 07 03:57 AM
do anybody have a sample code for executing excel macro from vb code?<eom	B Deepak	Excel Programming	2	September 30th 05 09:59 AM
stubborn Excel crash when editing code with code, one solution	Brian Murphy	Excel Programming	0	February 20th 05 05:56 AM
VBA code delete code but ask for password and unlock VBA protection	WashoeJeff	Excel Programming	0	January 27th 04 07:07 AM

Menu

About Us