+ Reply to Thread
Results 1 to 6 of 6

delete #N/A's in Excel

  1. #1
    Mjoddie
    Guest

    delete #N/A's in Excel

    How do I get the N/A's in cells to not appear after doing a vlookup and there
    is no value that match in the 2 spreadsheets? What I have is a complete
    inventory and movement of my product and I bring in a customers inventory and
    they do not stock all the numbers in my line. In any cell that the customer
    does not stock my product I get a #N/A.

  2. #2
    David Billigmeier
    Guest

    RE: delete #N/A's in Excel

    Hello -
    You can add a check before doing the vlookup:

    =IF(ISNA(VLOOKUP(...)),"",VLOOKUP(...))

    Hope that helps,
    --
    David Billigmeier


    "Mjoddie" wrote:

    > How do I get the N/A's in cells to not appear after doing a vlookup and there
    > is no value that match in the 2 spreadsheets? What I have is a complete
    > inventory and movement of my product and I bring in a customers inventory and
    > they do not stock all the numbers in my line. In any cell that the customer
    > does not stock my product I get a #N/A.


  3. #3
    Alan
    Guest

    Re: delete #N/A's in Excel

    =IF(ISNA(Your Vlookup Formula)),"Value, error message or
    whatever",VLOOKUP(Your VLOOKUP Formula))
    Regards,
    Alan.
    "Mjoddie" <[email protected]> wrote in message
    news:[email protected]...
    > How do I get the N/A's in cells to not appear after doing a vlookup and
    > there
    > is no value that match in the 2 spreadsheets? What I have is a complete
    > inventory and movement of my product and I bring in a customers inventory
    > and
    > they do not stock all the numbers in my line. In any cell that the
    > customer
    > does not stock my product I get a #N/A.




  4. #4
    Mjoddie
    Guest

    RE: delete #N/A's in Excel



    "David Billigmeier" wrote:

    > Hello -
    > You can add a check before doing the vlookup:
    >
    > =IF(ISNA(VLOOKUP(...)),"",VLOOKUP(...))
    >
    > Hope that helps,
    > --
    > David Billigmeier
    >
    >
    > "Mjoddie" wrote:
    >
    > > How do I get the N/A's in cells to not appear after doing a vlookup and there
    > > is no value that match in the 2 spreadsheets? What I have is a complete
    > > inventory and movement of my product and I bring in a customers inventory and
    > > they do not stock all the numbers in my line. In any cell that the customer
    > > does not stock my product I get a #N/A.


    David, I have copied my formula =VLOOKUP(A7,'Fuel
    Pumps'!$A$2:$D$134,4,FALSE) Where would I put your check?

  5. #5
    Mjoddie
    Guest

    RE: delete #N/A's in Excel

    I get it. You do not write Quot you put a " mark in!!

    Thank you,

    Mike

    "David Billigmeier" wrote:

    > Hello -
    > You can add a check before doing the vlookup:
    >
    > =IF(ISNA(VLOOKUP(...)),"",VLOOKUP(...))
    >
    > Hope that helps,
    > --
    > David Billigmeier
    >
    >
    > "Mjoddie" wrote:
    >
    > > How do I get the N/A's in cells to not appear after doing a vlookup and there
    > > is no value that match in the 2 spreadsheets? What I have is a complete
    > > inventory and movement of my product and I bring in a customers inventory and
    > > they do not stock all the numbers in my line. In any cell that the customer
    > > does not stock my product I get a #N/A.


  6. #6
    David Billigmeier
    Guest

    RE: delete #N/A's in Excel

    The double quotation mark ("") will output a blank space. Change that to
    whatever you want your error message to read (i.e. "no match")

    --
    David Billigmeier


    "Mjoddie" wrote:

    > I get it. You do not write Quot you put a " mark in!!
    >
    > Thank you,
    >
    > Mike
    >
    > "David Billigmeier" wrote:
    >
    > > Hello -
    > > You can add a check before doing the vlookup:
    > >
    > > =IF(ISNA(VLOOKUP(...)),"",VLOOKUP(...))
    > >
    > > Hope that helps,
    > > --
    > > David Billigmeier
    > >
    > >
    > > "Mjoddie" wrote:
    > >
    > > > How do I get the N/A's in cells to not appear after doing a vlookup and there
    > > > is no value that match in the 2 spreadsheets? What I have is a complete
    > > > inventory and movement of my product and I bring in a customers inventory and
    > > > they do not stock all the numbers in my line. In any cell that the customer
    > > > does not stock my product I get a #N/A.


+ Reply to Thread

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