I have tried many ways of returning a 0 instead of a #NA in my formula but i cannot seem to get it to work.
this is what i have tried so far:
=IF(ISNA(VLOOKUP(A3,Sheet2!$A$3:$C$65536,2,0)),0,VLOOKUP(A3,Sheet2!$A$3:$C$65536,2,0)
=IF(ISNA(VLOOKUP(A3,Sheet2!$A$3:$C$65536,2,0)),"",(VLOOKUP(A3,Sheet2!$A$3:$C$65536,2,0)
any help please?
this is what i have tried so far:
=IF(ISNA(VLOOKUP(A3,Sheet2!$A$3:$C$65536,2,0)),0,VLOOKUP(A3,Sheet2!$A$3:$C$65536,2,0)
=IF(ISNA(VLOOKUP(A3,Sheet2!$A$3:$C$65536,2,0)),"",(VLOOKUP(A3,Sheet2!$A$3:$C$65536,2,0)
any help please?