How to replae #NA with 0
 

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

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

How to replae #NA with 0
 

On Aug 5, 1:05 pm, "Arvi Laanemets" wrote:
Hi

=IF(ISNA(VLOOKUP(...)),0,VLOOKUP(...))
or
=IF(ISERROR(VLOOKUP(...)),0,VLOOKUP(...))

Arvi Laanemets

hi Arvi

It works well thank you very much for your support
SG

"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- Hide quoted text -

- Show quoted text -