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