Making #N/A invisible
VBA Telemetry pings you when your VBA projects fail
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 2 of 2

Thread: Making #N/A invisible

  1. #1


    I have been trying to get rid of some unsightly #N/A s on an Excel Spreadsheet until input is received. I had contemplated changing them to Zeros but I seem to be unable to get an IF statement to acknowledge them. I wonder is there an easy/smart way. Any help appreciated

  2. #2
    Rest in Peace
    Join Date
    Feb 2002
    Post Thanks / Like
    0 Post(s)
    0 Thread(s)



    Not too sure if you just want to not see the #N/A or prevent it. If the former use Conditional formatting (under Format) and set the "Formula is" to: =ISNA($D$7) and then change the Font color and background color to the same.

    If you are wanting prevent it here are a few options using the VLOOKUP:



    The first method is the preferred one.

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts