How can I change an #N/A error to display other text?

's Computer Specifications

I have entered a vlookup formula that returns an #N/A error until the data is
found. What I would like to do is to display this #N/A as meaningful text
such as "unpresented".

's Computer Specifications

Try this,

=If(Isna(Vlookup(...)),"unpresented",Vlookup(...))

"Nelly" <(E-Mail Removed)> wrote in message
news:BED79487-78E7-4898-BFF4-(E-Mail Removed)...
>I have entered a vlookup formula that returns an #N/A error until the data
>is
> found. What I would like to do is to display this #N/A as meaningful text
> such as "unpresented".

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

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Why does Outlook display text in yellow? How can i change it?	Wise Dog	Microsoft Outlook Discussion	1	20th May 2010 02:39 PM
How do you change text to display in small capitals in Word 2007:	eaglesight	Microsoft Word Document Management	5	28th Feb 2008 03:02 AM
How do I change button images to display text in Excel 2007?	=?Utf-8?B?bWNoODMx?=	Microsoft Excel New Users	1	29th Sep 2007 01:20 AM
How to change text display upright of buttons?	news	Microsoft C# .NET	1	8th Aug 2006 05:29 AM
Change #Error to display 0	Eric	Microsoft Access Reports	1	19th Nov 2004 09:21 PM