+ Reply to Thread
Results 1 to 2 of 2

#N/a Displayed in Lookup Tables

  1. 07-30-2013, 06:17 PM #1
    pappanerf
    pappanerf is offline
    Registered User
    Join Date
    07-30-2013
    Location
    CedarRapids, Iowa USA
    MS-Off Ver
    Excel 2007
    Posts
    1

    #N/a Displayed in Lookup Tables

    How can I suppress the #N/A displayed in a lookup table? I'd like to show either blanks or zeros.

    Thanks,
    Reply With QuoteRegister To Reply
  2. 07-30-2013, 06:34 PM #2
    Sam Capricci
    Sam Capricci is offline
    Forum Expert Sam Capricci's Avatar
    Join Date
    06-14-2012
    Location
    Palm Harbor, Florida
    MS-Off Ver
    16.84 for Mac MS 365
    Posts
    8,504

    Re: #N/a Displayed in Lookup Tables

    including iferror in your formulas usually does it.
    to get more info though you'll need to supply more detail.
    Last edited by Sam Capricci; 07-30-2013 at 06:38 PM.
    Make contributors happy, click on the "* Add Reputation" as a way to say thank you.
    Sam Capricci
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Set number value displayed in cell when certain text value is displayed in another
    By chrisswann in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 06-18-2013, 09:07 AM
  2. Lookup with multiple results to be displayed
    By LottieCampbell in forum Excel General
    Replies: 1
    Last Post: 07-16-2012, 01:27 PM
  3. [Solved] 2 way lookup between tables
    By joedrummer in forum Excel General
    Replies: 4
    Last Post: 01-28-2012, 12:49 PM
  4. Lookup in sub-tables
    By djws in forum Excel Formulas & Functions
    Replies: 12
    Last Post: 08-12-2008, 05:39 PM
  5. Looking for some help: Lookup tables
    By Paul_colt in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 08-15-2007, 03:38 PM

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1