Loading
Ozgrid Excel Help & Best Practices Forums

Excel Video Tutorials / Excel Dashboards Reports



Results 1 to 5 of 5

Thread: Replace VLOOKUP #N/A error with blank or zero

  1. #1
    Join Date
    3rd July 2010
    Posts
    2

    Replace VLOOKUP #N/A error with blank or zero

    While using vllookup am having trouble with the result when value is not recognized or even present. I would like the result in the cell to be blank if the value sought is not found. Am now getting #N/A or just #. As I'm trying to sum the results am failing miserably!! Any help please

    WilliamO
    Last edited by AAE; July 31st, 2010 at 00:31. Reason: revise thread title

    Excel Video Tutorials / Excel Dashboards Reports


  2. #2
    Join Date
    19th January 2007
    Location
    South Carolina, USA
    Posts
    9,084

    Re: Replace VLOOKUP #N/A error with blank or zero

    Ivanhoe,

    Welcome to the Ozgrid community.

    Because thread titles are important for obtaining good search results they should be written with this thought in mind - that is, the thread title should be "search friendly", meaning a searchusing YOUR title as the search terms would yield relevant results. Thread titles should concisely nd accurately describe the contents of your thread. A single word title like "vlookup" is inadequate as it is too generic and does not fully describe your thread.

    Note the change made to your thread title as an example and in future threads take care to give the thread a title that more acurrately reflects your thread content. Thanks.

    There a MANY posts on this topic and more than one way to deal with this issue;
    See these links on the VLOOKUP #N/A Error
    AAE
    ----------------------------------------------------

    Forum Rules | Message to Cross Posters | How to use Tags

  3. #3
    Join Date
    3rd July 2010
    Posts
    2

    Re: Replace VLOOKUP #N/A error with blank or zero

    Many thanks for the post and the advice re describing the problem being experienced. Will make sure I'll do it better next time. Got the answer I needed and it works well with my project. BTW do you have any advice re VBA for Excel as I've done zero work with this sort of thing and as am retired and doing just odd jobs with spreadsheets for friends and businesses in the area am wondering how useful it could be. And also am wondering how attainable a working knowledge in VBA could be learned this way. Any thoughts? Ivanhoe (William)

    Excel Video Tutorials / Excel Dashboards Reports


  4. #4
    Join Date
    10th June 2010
    Location
    Seattle, WA
    Posts
    451

    Re: Replace VLOOKUP #N/A error with blank or zero

    If you're at all technically inclined, or just get a kick out of figuring out how to simplify a complex or tedious/repetitious task, then I believe it would most definitely be worth your while to acquire some familiarity with VBA.

    Particularly in Excel, it is a readily attainable skill, and you can start small and build from there. The macro recorder will capture the command syntax required for most actions you can carry out using the toolbars (or ribbons in 2007 and later). There are some excellent reference books available to help - for the complete novice, John Walkenbach's VBA Programming for Dummies series is quite good (with editions for each version of Excel).

    Most important advice for starting out: while the macro recorder will show you commands using the "Select" method, when you go to write your own code, it is nearly always unnecessary. You can reference cells, sheets, workbooks, rows, columns etc. without having to select them. Another extremely useful trick to master early is assigning excel objects to variables, allowing you to operate on them without having to key long detailed names for them over and over.

    Good luck! And know that you'll find lots of willing helpers in forums like this one.

    Excel Video Tutorials / Excel Dashboards Reports


  5. #5
    Join Date
    19th January 2007
    Location
    South Carolina, USA
    Posts
    9,084

    Re: Replace VLOOKUP #N/A error with blank or zero

    For VBA training, this might be of interest if you want a more "formal" approach than just digging through books.

    Ozgrid VBA Training

    Additionally, do a web search on the topic as well as make use YouTube. There are some decent, free, beginner tutorials around.
    As Barb stated, the macro recorder is your friend and you can learn much, although the code it spits outs isn't the mode efficient, but that's where the forum comes - getting experienced help to review and help tweak it.

    Download and study the code/workbooks/projects of others then post specific questions.
    AAE
    ----------------------------------------------------

    Forum Rules | Message to Cross Posters | How to use Tags

Thread Information

Users Browsing this Thread

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

Possible Answers

  1. Vlookup Based On Results From A Vlookup
    By pzarate in forum EXCEL HELP
    Replies: 1
    Last Post: June 9th, 2007, 03:49
  2. Help: vlookup
    By abbott in forum EXCEL HELP
    Replies: 12
    Last Post: July 20th, 2005, 20:38
  3. VLOOKUP w/out getting #N/A
    By Arkansas in forum EXCEL HELP
    Replies: 3
    Last Post: July 14th, 2005, 02:10
  4. Help with IF And/Or VLOOKUP
    By bassrm125 in forum EXCEL HELP
    Replies: 3
    Last Post: June 2nd, 2004, 22:06

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