Vlookup & IF formula needed

Hi

I am doing some vlookups but when a cell is blank it displays a '0'. I tried adding iferror with ,"" but this did not work. The data being looked up is text and numbers.

I have attached an example. On the 'Output' sheet I need the boxes in red to be blank.

Any ideas?

Thanks