vlookup returning 0 value when told not to

I've had this problem for sometime and while its not hindering me right now it does create a bit of visual confusion on the screen and when trying to distribute a report to co-workers. I've have a sheet that I use the vlookup function on and when told to display nothing in the event of an isna value it will display a 0 instead. I've attached a copy of the sheet so you can dissect as necessary. Again it references properly when data is present but not when there is an absence of data. Use column D as a reference for the error, cell D14 is the first instance of this error. I've tried different formats for the cells as well.