=IFERROR(VLOOKUP(A4,'[Supplier TO analysis template.xlsx]2015'!$A$5:$C$111,2,FALSE),0)
=IF(COUNTIF('[Supplier TO analysis template.xlsx]2015'!$A$5:$A$111,A4),VLOOKUP(A4,'[Supplier TO analysis template.xlsx]2015'!$A$5:$C$111,2,FALSE),0)
=IF(ISNA(MATCH(A4,'[Supplier TO analysis template.xlsx]2015'!$A$5:$A$111,0)),0,VLOOKUP(A4,'[Supplier TO analysis template.xlsx]2015'!$A$5:$C$111,2,FALSE))
=IF(ISNA(VLOOKUP(A4,'[Supplier TO analysis template.xlsx]2015'!$A$5:$C$111,2,FALSE)),0,VLOOKUP(A4,'[Supplier TO analysis template.xlsx]2015'!$A$5:$C$111,2,FALSE))