=if(iserror(vlookup(...)),0,vlookup(....))



Arla wrote:

I am using a VLookup function. I need to find an exact match, but when there
is no match, I would like to see a zero, rather than #N/A. Can someone help
me with a different formula to produce similar results as I am getting with
the VLookup without the #N/A?

--

Dave Peterson