Thread: How can I change an #N/A error to display other text?
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
nelly nelly is offline
external usenet poster
  
Posts: 31
Default How can I change an #N/A error to display other text?
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".
Reply With QuoteReply With Quote