Results 1 to 6 of 6

#N/A Workaround

Threaded View

  1. #1
    Registered User
    Join Date
    08-10-2010
    Location
    OOOOklahoma
    MS-Off Ver
    Excel 2007
    Posts
    19

    #N/A Workaround

    I have a Vlookup that is returning the value #N/A. Is there a way to enter a conditional format:
    =If(a1="#N/A",1,0)
    I tried this equation and it did not work.
    Is there anyway to work around this?
    Last edited by mcantrell; 08-16-2010 at 03:53 PM.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1