To deal with #NA

's Computer Specifications

i want to stop the #N/A showing in my cells where the VLookup has been used
is it possiblt to stop them from showing when a a lookup value is not yet
available.

's Computer Specifications

see http://www.ozgrid.com/Excel/stop-na-vlookup.htm

--
Regards
Dave Hawley
www.ozgrid.com
"Amin" <(E-Mail Removed)> wrote in message
news:37FE3F4E-D7CD-43F1-9B96-(E-Mail Removed)...
>i want to stop the #N/A showing in my cells where the VLookup has been used
> is it possiblt to stop them from showing when a a lookup value is not yet
> available.

's Computer Specifications

One wa is to use ISNA() IF() combination to handle the error

=IF(ISNA(vlookupformula),"",vlookupformula)

--
Jacob (MVP - Excel)

"Amin" wrote:

> i want to stop the #N/A showing in my cells where the VLookup has been used
> is it possiblt to stop them from showing when a a lookup value is not yet
> available.

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Has anyone made a Deal or No Deal Gameboard?	kajunlion@yahoo.com	Microsoft Excel Programming	2	17th Apr 2008 12:12 AM
Has anyone made a Deal or No Deal Gamebord	kajunlion@yahoo.com	Microsoft Excel Misc	2	17th Apr 2008 12:12 AM
Deal or no deal dvd game(UK)	michael555	Gaming	4	1st Jan 2007 09:13 PM
AMD64 or Semperon, deal or no deal?	Tad Confused	Computer Hardware	13	13th Apr 2006 06:43 PM
Re: Is this 181 GB drive on EBay a good deal or a bad deal?	GMAN	Storage Devices	0	24th Jun 2003 08:45 AM