Thread: #N/A
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Ken Ken is offline
external usenet poster
 
Posts: 590
Default #N/A

How can I hide the #N/A results on formulas that are showing up on my
spreadsheets. The results that I am getting are tied into VLOOKUP, and I
have to use this function to complete the multiple needs for this report. If
the respective line does not apply at that given time I get the #N/A result.
I would rather the cell remain "empty". I have looked at all of the
suggestions, but nothing appears to be working for me...HELP