Power Query Course in Spanish
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 8 of 8

Thread: dont display errors

  1. #1
    Board Regular
    Join Date
    Feb 2002
    Posts
    229
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    if i am doing a vlookup -- how can i prevent an error from showing, i would be happy with a dash in its place.

    thanks

    rich

    [ This Message was edited by: richiejjj on 2002-03-25 05:47 ]

  2. #2
    Board Regular
    Join Date
    Mar 2002
    Location
    Leiden, The Netherlands
    Posts
    68
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    You might try:

    =IF(ISNA(VLOOKUP(whatever));"-";VLOOKUP(whatever))

    I don't know of any way to format errors.

    marc

  3. #3
    MrExcel MVP
    Join Date
    Feb 2002
    Location
    Bogota, Colombia
    Posts
    11,959
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    I would suggest this instead:

    If your current formula looks something like:

    =VLOOKUP(A1,$C$1:$E$100,3,0)

    replace it with

    =IF(COUNTIF($C$1:$C$100,A1),VLOOKUP(A1,$C$1:$E$100,3,0),"")

    Regards,

    Juan Pablo González
    http://www.juanpg.com

  4. #4
    Board Regular
    Join Date
    Feb 2002
    Posts
    229
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    excellent thank you

  5. #5
    Board Regular
    Join Date
    Feb 2002
    Posts
    229
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    further to the earlier question , how can i adapt this to not show results of formulaes that would produce an error:

    i.e. #DIV/0!

    thanks

  6. #6
    MrExcel MVP
    Join Date
    Feb 2002
    Location
    Millbank, London, UK
    Posts
    1,790
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    you should be able to tailor the =error.type function to your requirements where you only want to "hide" or "replace" certain types of errors

    check out the help file on error types
    :: Pharma Z - Family drugstore ::

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

    Default

    On 2002-03-25 09:20, Richiejjj wrote:
    further to the earlier question , how can i adapt this to not show results of formulaes that would produce an error:

    i.e. #DIV/0!

    thanks
    It's better to prevent occurrence of errors like the one you cite.

    =IF(B1,A1/B1,0)

    where B1 is of numeric type, is better than just:

    =A1/B1

    which will give #DIV/0! if B1 can be 0 or empty.

  8. #8
    Board Regular
    Join Date
    Feb 2002
    Posts
    229
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    great thanks!

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
  •