Thread: How do I replace a "#N/A" formula result with a blank in excel?
View Single Post
  #7   Report Post  
Posted to microsoft.public.excel.misc
RODY
 
Posts: n/a
Default How do I replace a "#N/A" formula result with a blank in excel?
=IF(ISNA(VLOOKUP)),"",VLOOKUP())

"yrat" wrote:

As a result of a Vlookup formula a cell gives #N/A. The formula and the data
that it looks up is good. It should give a #N/A. I need the cell instead of
displaying #N/A to display nothing (blank) without deleting the formula.
Reply With QuoteReply With Quote