how to convert #na to 0 when using vlookup

[Guest]

When I use Vlookup, #NA returned if the vulue is not found. I need help to
convert #NA to zero or blank. Please help and thanks!

 

[Peo Sjoblom]

=IF(ISNA(vlookup),"",vlookup)

replace vlookup with your formula


--


Regards,


Peo Sjoblom

 

[Guest]

try =if(isna(your_vlookup),0,your_vlookup)

 

[georgeami]

much easyer "=IFERROR(VLOOKUP,0) Replace "Vlookup" with your formula and it will return 0 instead #N/A.