Results 1 to 2 of 2

Thread: VLOOKUP and IFNA give me a 0 when data exists
Thanks Thanks: 0 Likes Likes: 0

  1. #1
    Board Regular
    Join Date
    Mar 2015
    Posts
    95
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default VLOOKUP and IFNA give me a 0 when data exists

    I have 2 workbooks i want to pull data from and merge into one main page, I have followed the instructions per this Youtube video, but I am getting a 0 in over 50% of the fields that have a valid value.

    Video source: https://www.youtube.com/watch?v=yea2Zvb8Q7s

    Here is my formula:

    =IFNA(VLOOKUP(A213,ASIN1!$A$2:$E$1387,5,FALSE),VLOOKUP(A213,ASIN2!$A$2:$E$1381,5,FALSE))


    It works for some, and doesnt for others, not sure what the pattern is at the moment.

    I am using Office 365, not sure if i should use IFNA or IFERROR.

    Any help would be appreciated.

    Thank you
    Last edited by i8ur4re; Sep 19th, 2019 at 08:23 PM.

  2. #2
    Board Regular Toadstool's Avatar
    Join Date
    Mar 2018
    Posts
    227
    Post Thanks / Like
    Mentioned
    9 Post(s)
    Tagged
    2 Thread(s)

    Default Re: VLOOKUP and IFNA give me a 0 when data exists

    Hi i8ur4re,

    The formula works fine for me as you have it written. The only time I see 0 is if the matching E column value is 0 or it is an empty cell.

    A B
    213 XYZ 88
    214 ABC Hello
    215 PUP #N/A
    216 DOG 0
    217 TTT 0
    i8ur4re

    Worksheet Formulas
    Cell Formula
    B213
    to
    B217
    =IFNA(VLOOKUP(A213,ASIN1!$A$2:$E$1387,5,FALSE),VLOOKUP(A213,ASIN2!$A$2:$E$1381,5,FALSE))




    A B C D E
    1 Code Number
    2 XXY 1
    3 PPP 2
    4 ABC Hello
    ASIN1




    A B C D E
    1 Code Number
    2 FFD 11
    3 DOG
    4 XXS 33
    5 TTT 0
    6 XYZ 88
    ASIN2
    Life advice found on a book of matches: "Keep cool. Keep away from children."

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
  •