Thread: vlookup - replace #N/A with text - Excel 2003
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Charlotte Howard Charlotte Howard is offline
external usenet poster
  
Posts: 37
Default vlookup - replace #N/A with text - Excel 2003
Hi,
Is it possible to replace a #N/A result with a particular text string? I
know I could use Find/Replace, but I really don't want to lose the formula.
Thanks for any help
Charlotte
Reply With QuoteReply With Quote