Is this what you are after?

=IF(LEN(E12)=0,"",IFERROR(INDEX(Assignments[Description],MATCH(E12,Assignments!$D$4:$D$15,0)),""))