Results 1 to 4 of 4

Thread: Get rid of the 0 in a Vlookup
Thanks Thanks: 0 Likes Likes: 0

  1. #1
    New Member
    Join Date
    Jul 2016
    Location
    Ca, Usa
    Posts
    13
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Get rid of the 0 in a Vlookup

    Hi All,
    I hope that you can help. I have 4 tabs on this sheet. 1st tab is my shipping info that I drop into the sheet and 3 of them have info I need to reference from. The problem is I keep getting 0 on half my look ups. So I tried to use =IFNA(IF(VLOOKUP(A2,'Redding '!A:P,16,FALSE)=0,"",VLOOKUP(A2,'Redding '!A:P,16,FALSE)),"") Which need deed did work but how do I combine the other 2 tabs to find all the info I need. So I tried this way

    =IFNA(IF(MATCH(A2,'Redding '!A:A,0),VLOOKUP(A2,'Redding '!A:R,15,FALSE),IF(MATCH(A2,'Mound City-Tecate'!A:A,0),VLOOKUP(A2,'Mound City-Tecate'!A:Q,15,FALSE),IF(MATCH(A2,'Tecate-Sewing'!A:A,0),VLOOKUP(A2,'Tecate-Sewing'!A:Q,15,FALSE),""))),"")

    But then I'm getting those darn 0's again.

  2. #2
    Board Regular DanteAmor's Avatar
    Join Date
    Dec 2018
    Location
    México
    Posts
    4,541
    Post Thanks / Like
    Mentioned
    42 Post(s)
    Tagged
    12 Thread(s)

    Default Re: Get rid of the 0 in a Vlookup

    Try this

    =IFERROR(VLOOKUP(A2,Redding!A:O,15,0),IFERROR(VLOOKUP(A2,'Mound City-Tecate'!A:O,15,0),IFERROR(VLOOKUP(A2,'Tecate-Sewing'!A:O,15,0),"Does not exist")))
    Regards Dante Amor

  3. #3
    New Member
    Join Date
    Jul 2016
    Location
    Ca, Usa
    Posts
    13
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Get rid of the 0 in a Vlookup

    Thanks Dante that works perfect

  4. #4
    Board Regular DanteAmor's Avatar
    Join Date
    Dec 2018
    Location
    México
    Posts
    4,541
    Post Thanks / Like
    Mentioned
    42 Post(s)
    Tagged
    12 Thread(s)

    Default Re: Get rid of the 0 in a Vlookup

    I'm glad to help you. Thanks for the feedback.
    Regards Dante Amor

Some videos you may like

User Tag List

Tags for this Thread

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
  •