how to convert #na to 0 when using vlookup

D

Diane

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!
 
P

Peo Sjoblom

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

replace vlookup with your formula


--


Regards,


Peo Sjoblom
 
Top