Announcement

Collapse
No announcement yet.

Stop VLOOKUP #N/A! Error

Collapse
X
  • Filter
  • Time
  • Show
Clear All
new posts

  • Stop VLOOKUP #N/A! Error



    Hi everybody,
    When I have the Vlookup formula and the field where I have the data to lookup is empty I get a sign with a number symbol and N/A, how can I tell excel not to show me this when the field where I type the information that I want to look is empty?. I want all the formulas fields to show nothing.
    Last edited by shg; May 12th, 2007, 05:16. Reason: Edit title

  • #2
    Re: Stop VLOOKUP #N/A! Error

    This site is a treasure trove of information. I did a search for VLOOKUP Error, and this is the first thing I found.
    Last edited by shg; May 13th, 2007, 02:44. Reason: Edit title
    Entia non sunt multiplicanda sine necessitate.

    Comment


    • #3
      Re: Stop VLOOKUP #N/A! Error

      Try this:

      =IF(ISERROR(<VLOOKUPSTRING>),"",<VLOOKUPSTRING>)
      Last edited by shg; May 13th, 2007, 02:43. Reason: Title

      Comment


      • #4
        Re: Stop VLOOKUP #N/A! Error

        If your VLOOKUP is something like

        =VLOOKUP(A1,B1:C10,2,0)

        change to

        =IF(A1="","",VLOOKUP(A1,B1:C10,2,0))
        Last edited by shg; May 13th, 2007, 02:43. Reason: title

        Comment


        • #5
          Re: Stop VLOOKUP #N/A! Error

          There are five possible answers at the bottom of the page!
          Hope that Helps

          Roy

          New users should read the Forum Rules before posting

          For free Excel tools & articles visit my web site

          If I have helped you and you feel like putting your hand in your pocket please make a donation to Children in Need

          RoyUK's Web Site

          royUK's Database Form

          Where to paste code from the Forum

          About me.

          Comment


          • #6
            Re: Stop VLOOKUP #N/A! Error

            Originally posted by royUK
            There are five possible answers at the bottom of the page!
            Although none of these actually addresses the specific question posed. Of course you could use ISNA or ISERROR but if the aim is only to return blank when the lookup value is blank, which is what was asked, then the example I posted would suffice

            Comment


            • #7


              Re: Stop VLOOKUP #N/A! Error

              Originally posted by daddylonglegs
              Although none of these actually addresses the specific question posed. Of course you could use ISNA or ISERROR but if the aim is only to return blank when the lookup value is blank, which is what was asked, then the example I posted would suffice
              I wasn't suggesting anything wrong with your answer, just pointing out that there were answers to look at generated below the question!
              Hope that Helps

              Roy

              New users should read the Forum Rules before posting

              For free Excel tools & articles visit my web site

              If I have helped you and you feel like putting your hand in your pocket please make a donation to Children in Need

              RoyUK's Web Site

              royUK's Database Form

              Where to paste code from the Forum

              About me.

              Comment

              Working...
              X