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

1. 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.

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

2. 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