Results 1 to 3 of 3

Thread: Need help to get rid of #n/a error in Excel Vlookup

  1. #1
    Join Date
    Oct 2011
    Posts
    91

    Need help to get rid of #n/a error in Excel Vlookup

    I am using vlookup in excel to pull select data from a worksheet. The problem is that the value I'm seeking isn't always in the table array. So, I get a #n/a error. The #n/a then prevents me from summing the data that I am collecting using the vlookup. How do I make the #n/a go away or equal zero so I can sum the data.

  2. #2
    Join Date
    May 2011
    Posts
    523

    Re: Need help to get rid of #n/a error in Excel Vlookup

    Try one of these. Returns a blank: =IF(ISNA(VLOOKUP(.....)),"",VLOOKUP(.....)). Returns a 0: =IF(ISNA(VLOOKUP(.....)),0,VLOOKUP(.....)). If you're using Excel 2007 try one of these:
    • =IFERROR(VLOOKUP(.....),"")
    • =IFERROR(VLOOKUP(.....),0)

    Note those will trap *all* errors, not just #N/A.

  3. #3
    Join Date
    Nov 2010
    Posts
    503

    Re: Need help to get rid of #n/a error in Excel Vlookup

    Is this still true for Excel 2007. Because I tried the top one, and it still left 0's in the column. Try using if(iserror(vlookup(Value,Table,column,0)),"your response",(vlookup(Value,Table,column,0)))

Similar Threads

  1. How to get yes or no in Vlookup in Excel
    By Gurmeet in forum MS Office Support
    Replies: 2
    Last Post: 24-01-2012, 04:57 PM
  2. How to Copy formula using Vlookup on Excel?
    By Chellappan in forum Windows Software
    Replies: 2
    Last Post: 04-01-2012, 08:20 PM
  3. Excel - Multiple vlookup
    By mike_2011 in forum Windows Software
    Replies: 1
    Last Post: 28-07-2011, 03:40 AM
  4. vlookup pictures in excel
    By Olivia in forum Software Development
    Replies: 6
    Last Post: 16-07-2011, 11:02 AM
  5. Vlookup problem in Excel
    By Hebrew in forum Windows Software
    Replies: 5
    Last Post: 02-01-2010, 07:28 PM

Tags for this Thread

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
  •  
Page generated in 1,711,621,927.99586 seconds with 17 queries