How to change #NA to 0 in Vlookup

[ritters]

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?

 

[AlphaFrog]

This seems to work...

=IF(ISNA(VLOOKUP(A3,Sheet2!$A$3:$C$65536,2,0)),0,VLOOKUP(A3,Sheet2!$A$3:$C$65536,2,0))

 

[SteveO59L]

This works for me

=IF(ISNA(VLOOKUP(B1,A:A,1,FALSE)),0,VLOOKUP(B1,A:A,1,FALSE))

 

[bosco_yip]

Or one of…….

=IF(ISNUMBER(MATCH(A3,Sheet2!A:A,0)),VLOOKUP(A3,Sheet2!$A:$C,2,0),0)

=IF(COUNTIF(Sheet2!A:A,A3),VLOOKUP(A3,Sheet2!$A:$C,2,0),0)

Regards
Bosco