Error Checking in Excel
Thanks Thanks:  0
Likes Likes:  0
Page 3 of 3 FirstFirst 123
Results 21 to 23 of 23

Thread: Ignore #N/A Value with Vlookup???

  1. #21
    MrExcel MVP
    Join Date
    Feb 2002
    Location
    Austin, Texas USA
    Posts
    11,654
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    On 2002-04-25 08:29, Parra wrote:
    Thank you to everyone that helped me with this. I guess I was looking to do it a certain way when there were easier ways to do it. I ended up doing a SUMIF functions.

    Aladin, Yogi Thanks
    You made a good choice!

  2. #22
    MrExcel MVP Aladin Akyurek's Avatar
    Join Date
    Feb 2002
    Location
    The Hague, NL
    Posts
    83,647
    Post Thanks / Like
    Mentioned
    33 Post(s)
    Tagged
    6 Thread(s)

    Default

    On 2002-04-25 08:30, Mark W. wrote:
    On 2002-04-25 08:29, Parra wrote:
    Thank you to everyone that helped me with this. I guess I was looking to do it a certain way when there were easier ways to do it. I ended up doing a SUMIF functions.

    Aladin, Yogi Thanks
    You made a good choice! [img]/board/images/smiles/icon_smile.gif[/img]
    I concur.

  3. #23
    New Member
    Join Date
    Nov 2013
    Posts
    1
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Ignore #N/A Value with Vlookup???

    Please Please Please... The best and the easiest solution in case of #NA or any other error for the matter is to use "=IFERROR".

    E.g. If you trying to divide 3 and zero (=A1/A2), you will get an error saying #Div/0!. All you need to do is insert "iferror" into the formula. Like this =IFERROR(A1/A2,"0"), Syntax=IFERROR(Value,Value_if_error). Thus Excel will return the Value "0" only if there is an error.

    You can use any Value other than "0". "-" is a very comman practice. You can even have text, just add "There is a zero in division" and Excel will say so instead of "0".

    You can use this for any Error, "#Name, #Ref, etc, and just about any error in excel.

Some videos you may like

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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