Try

=IF(AND(NOT(ISBLANK($A28)),$A28<>0),IFERROR(VLOOKUP($A28,InstallTemp!$C:$J,2,FALSE),0),"")