=IF($A13=$A$330,0,IF(ISERROR(VLOOKUP(A13,A2:A153,1 ,0)),0,INDEX($B$1:$B$153,MATCH($A13,$A$1:$A$245,0) )))

Try this you're not using formula correctly without closing the paranthesis. try this will work.

if you still face any issue send me the sheet

Regards,
Mandeep Baluja
LearningZmyPassion
https://www.linkedin.com/profile/view?id=312532939
https://www.facebook.com/VBAEXCELSQL?ref=hl