+ Reply to Thread
Results 1 to 10 of 10

If #n/a

  1. #1
    Forum Contributor
    Join Date
    05-20-2008
    Posts
    162

    If #n/a

    Hello All,

    Is there a way of displaying a message - whether it be a message box or a userform, If #N/A appears in a cell from a VLOOKUP.

    Just so i can inform the user - that there is no information for this criteria.

    Regards

    Craig

  2. #2
    Forum Expert dilipandey's Avatar
    Join Date
    12-05-2011
    Location
    Dubai, UAE
    MS-Off Ver
    1997 - 2016
    Posts
    8,191

    Re: If #n/a

    Hi Craig,

    Yes..
    You can update you formula as =iferror(<your formula>,"No information for this criteria")


    Regards,
    DILIPandey

    <click on below 'star' if this helps>
    DILIPandey
    +91 9810929744
    dilipandey@gmail.com

  3. #3
    Forum Contributor dogberry's Avatar
    Join Date
    07-15-2012
    Location
    Wales, UK
    MS-Off Ver
    Excel 2010
    Posts
    624

    Re: If #n/a

    Hi

    ad iferrorr(your formula),"Missing")

    The word missing will turn up every time you have an error


    Chris
    Click my star if I helped Thanks

  4. #4
    Forum Expert
    Join Date
    11-28-2012
    Location
    Guatemala
    MS-Off Ver
    Excel 2010
    Posts
    2,394

    Re: If #n/a

    Dear JonesZoid:

    If you are using Excell 2007 or beyond you can use

    [code]
    Iferror(vlookup(..),"Error message")
    [code]

  5. #5
    Forum Expert dilipandey's Avatar
    Join Date
    12-05-2011
    Location
    Dubai, UAE
    MS-Off Ver
    1997 - 2016
    Posts
    8,191

    Re: If #n/a

    Hi Craig,

    Yes..
    You can update you formula as =iferror(<your formula>,"No information for this criteria")


    Regards,
    DILIPandey

    <click on below 'star' if this helps>

  6. #6
    Forum Contributor Legend Rubber's Avatar
    Join Date
    09-21-2012
    Location
    Tillsonburg, Ontario
    MS-Off Ver
    Excel 2010
    Posts
    392

    Re: If #n/a

    attached a sample workbook please...?
    You can use something like...?
    Please Login or Register  to view this content.

  7. #7
    Forum Guru Pete_UK's Avatar
    Join Date
    12-31-2011
    Location
    Warrington, England
    MS-Off Ver
    Office 2019 (still learning)
    Posts
    21,261

    Re: If #n/a

    For some reason none of your replies are showing on the New Posts list, so I'm just responding to see if that gets registered.

    Pete

  8. #8
    Forum Contributor
    Join Date
    05-20-2008
    Posts
    162

    Re: If #n/a

    Sorry all - been in the bath.....

    Thanks for all your help - i will try them out later - just need to attend to the family duties.....Kids are hungry....

    Thanks again all

    Craig

  9. #9
    Forum Contributor
    Join Date
    05-20-2008
    Posts
    162

    Re: If #n/a

    All,

    The Iferror works OK....but i would like a messagebox to pop up - to get the users attention.

    Would i be better using a workbook_change vba macro??

    Craig.

  10. #10
    Forum Contributor
    Join Date
    05-20-2008
    Posts
    162

    Re: If #n/a

    Found This - Which Works A Charm.
    All i have done is changed the msgbox text for the error i require.

    Please Login or Register  to view this content.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1