Here is the problem

I have a vlookup formula that looks up data in a specific table. now on occasion the vlookup will not find a result in the table and return with a #n/a. I understand why it is doing this but what i need to do is for the result to be a 0 instead of #n/a can i do this with conditional formating or something.

Thanks