Results 1 to 6 of 6

Thread: How do you replace Vlookup #NA errors with zero or blank cell

  1. #1

    How do you replace Vlookup #NA errors with zero or blank cell



    Register for a FREE account, and/
    or Log in to avoid these ads!

    How do you replace Vlookup #NA errors with zero or blank cell? Thanks!

  2. #2
    Seeker arup1032's Avatar
    Join Date
    Sep 2015
    Posts
    19
    Articles
    0
    Excel Version
    Excel 2013
    1) Just copy all the cell.
    2) Then click on your right button of mouse and select paste special from the menu. Then select values only. Or after copy just type alt+E+S+V to paste value.
    3) Then type ctrl+h and right #N/A on "find what" and leave empty the "replace with". Then hit enter.

    Your job will be done.

  3. #3
    Magician navic's Avatar
    Join Date
    Aug 2013
    Location
    Europe, Croatia
    Posts
    869
    Articles
    0
    Excel Version
    Excel 2013
    Quote Originally Posted by huyle2103 View Post
    How do you replace Vlookup #NA errors with zero or blank cell? Thanks!
    For Excel 2003
    Code:
    =IF(ISERROR(VLOOKUP-formula),"",VLOOKUP-formula)
    For Excel 2007 and later
    Code:
    =IFERROR(VLOOKUP-formula,"")
    My personal Web Excel Tutorials
    Attention! In the formulas as a delimiter I use a semicolon (; ) if you using my formula, then perhaps you need to use a comma (,)
    Also for a decimal number I use a comma (,) you may need to use point (.) instead of

  4. #4
    Magician Hercules1946's Avatar
    Join Date
    Mar 2013
    Location
    York, England
    Posts
    794
    Articles
    0
    Excel Version
    2010
    Quote Originally Posted by arup1032 View Post
    1) Just copy all the cell.
    2) Then click on your right button of mouse and select paste special from the menu. Then select values only. Or after copy just type alt+E+S+V to paste value.
    3) Then type ctrl+h and right #N/A on "find what" and leave empty the "replace with". Then hit enter.

    Your job will be done.
    Would you need to repeat this every time N/A arises in a different location?

  5. #5

  6. #6
    Quote Originally Posted by Hercules1946 View Post
    Would you need to repeat this every time N/A arises in a different location?
    Great video

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •