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
    Guest

    Default

     
    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
    Cheers
    Sam

  2. #2
    Rest in Peace
    Join Date
    Feb 2002
    Posts
    1,582
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

      
    Hi

    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:

    =IF(COUNTIF(A1:A500,"MyData")=0,"",VLOOKUP("MyData",A1:C500,2,FALSE))

    =IF(ISNA(VLOOKUP("MyData",A1:C500,2,FALSE)),"",VLOOKUP("MyData",A1:C500,2,FALSE))

    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
  •  

 

 
DMCA.com