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
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: