NA -Errors to show 0
 

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

NA -Errors to show 0
 

=IF(ISERROR(VLOOKUP([your vlookup]),0,VLOOKUP([your vlookup]))

Dave
--
Brevity is the soul of wit.


"Newbee" wrote:

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

NA -Errors to show 0
 

hello
=if(isna("yourVlookup_formula"),0,("yourVlookup_fo rmula"))

--
*****
birds of the same feather flock together..



"Newbee" wrote:

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

NA -Errors to show 0
 

Thank you very much!!

"Dave F" wrote:

=IF(ISERROR(VLOOKUP([your vlookup]),0,VLOOKUP([your vlookup]))

Dave
--
Brevity is the soul of wit.


"Newbee" wrote:

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

NA -Errors to show 0
 

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


On Tue, 30 Jan 2007 09:15:01 -0800, Newbee
wrote:

Thank you very much!!

"Dave F" wrote:

=IF(ISERROR(VLOOKUP([your vlookup]),0,VLOOKUP([your vlookup]))

Dave
--
Brevity is the soul of wit.


"Newbee" wrote:

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