How to replae #NA with 0

S

SG

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
 
A

Arvi Laanemets

Hi

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


Arvi Laanemets
 
S

SG

Hi

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

Arvi Laanemets
Click to expand...

hi Arvi

It works well thank you very much for your support
SG
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

vlookup repl #/NA with 0 2
Converting Text 9
replacing #NA with 0 3
Help with If and Vlookup Statement 1
Help with Vlookup Match and IF statement 2
How to convert VLOOPUP error value #NA to 0? 4
VLOOKUP 4
Or Function and #NA 2

Top