How to replae #NA with 0
Hi
=IF(ISNA(VLOOKUP(...)),0,VLOOKUP(...))
or
=IF(ISERROR(VLOOKUP(...)),0,VLOOKUP(...))
Arvi Laanemets
"SG" wrote in message
ps.com...
HI
Any one can guide me that how to replace #NA with 0, iam using vlookup
with match but i doesn't works well
thanks
|