Help with code please

Posted to microsoft.public.excel.programming

Greg[_27_] Greg[_27_] is offline

external usenet poster

Posts: 50

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

Reply With Quote

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

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

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

All times are GMT +1. The time now is 08:50 AM.

Menu

About Us