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
|