N
Newbee
Is there a way when you perform a VLook-up and the value is not found that
the formula will produce 0 instead of NA
the formula will produce 0 instead of NA
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
D
Dave F
=IF(ISERROR(VLOOKUP([your vlookup]),0,VLOOKUP([your vlookup]))
Dave
Dave
D
driller
hello
=if(isna("yourVlookup_formula"),0,("yourVlookup_formula"))
=if(isna("yourVlookup_formula"),0,("yourVlookup_formula"))
N
Newbee
Thank you very much!!
Dave F said:=IF(ISERROR(VLOOKUP([your vlookup]),0,VLOOKUP([your vlookup]))
Dave
--
Brevity is the soul of wit.
Newbee said:Is there a way when you perform a VLook-up and the value is not found that
the formula will produce 0 instead of NA
G
Gord Dibben
Just as long as you know that with ISERROR all errors will return 0, not just
the NA. You may be hiding something you should know about.
The ISNA trap will return 0 for data not found.
=IF(ISNA(VLOOKUP([your vlookup]),0,VLOOKUP([your vlookup]))
Gord Dibben MS Excel MVP
the NA. You may be hiding something you should know about.
The ISNA trap will return 0 for data not found.
=IF(ISNA(VLOOKUP([your vlookup]),0,VLOOKUP([your vlookup]))
Gord Dibben MS Excel MVP
Thank you very much!!
Dave F said:=IF(ISERROR(VLOOKUP([your vlookup]),0,VLOOKUP([your vlookup]))
Dave
--
Brevity is the soul of wit.
Newbee said:Is there a way when you perform a VLook-up and the value is not found that
the formula will produce 0 instead of NA