Loading
Ozgrid Excel Help & Best Practices Forums

Excel Video Tutorials / Excel Dashboards Reports



Results 1 to 7 of 7

Thread: Stop VLOOKUP #N/A! Error

  1. #1
    Join Date
    4th May 2007
    Posts
    8

    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 at 05:16. Reason: Edit title

    Excel Video Tutorials / Excel Dashboards Reports


  2. #2
    Join Date
    12th September 2006
    Location
    The Great State of Texas
    Posts
    4,323

    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 at 02:44. Reason: Edit title

    Excel Video Tutorials / Excel Dashboards Reports


  3. #3
    Join Date
    11th August 2006
    Location
    Outside St. Louis, MO
    Posts
    621

    Re: Stop VLOOKUP #N/A! Error

    Try this:

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

    Excel Video Tutorials / Excel Dashboards Reports


  4. #4
    Join Date
    24th April 2007
    Location
    England
    Posts
    675

    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 at 02:43. Reason: title

    Excel Video Tutorials / Excel Dashboards Reports


  5. #5
    Join Date
    26th January 2003
    Location
    Derbyshire,UK
    Posts
    18,298

    Re: Stop VLOOKUP #N/A! Error

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

    Roy

    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.

  6. #6
    Join Date
    24th April 2007
    Location
    England
    Posts
    675

    Re: Stop VLOOKUP #N/A! Error

    Quote 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

    Excel Video Tutorials / Excel Dashboards Reports


  7. #7
    Join Date
    26th January 2003
    Location
    Derbyshire,UK
    Posts
    18,298

    Re: Stop VLOOKUP #N/A! Error

    Quote 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

    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.

Thread Information

Users Browsing this Thread

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

Possible Answers

  1. Multiple IF Functions to Stop #N/A in VLOOKUP
    By ShawnIRQL in forum EXCEL HELP
    Replies: 4
    Last Post: August 25th, 2007, 15:27
  2. IF & VLOOKUP To Stop #N/A!
    By Ediese in forum EXCEL HELP
    Replies: 10
    Last Post: July 13th, 2007, 23:35
  3. Stop #Div/0! Error in Formula
    By SmokingMan in forum EXCEL HELP
    Replies: 12
    Last Post: May 6th, 2007, 11:00
  4. On Error Stop!?!
    By Vikxcel in forum EXCEL HELP
    Replies: 4
    Last Post: October 20th, 2005, 09:21
  5. Stop Vlookup Returning #N/A!
    By loglog58 in forum EXCEL HELP
    Replies: 15
    Last Post: December 18th, 2004, 12:21

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
  •  
porno