=IFERROR(IF(MATCH(B2,Staff!$F:$F,0),"Assigned"),"Not Assigned")
… MATCH(B2,Staff!$F:$G,0)…
=LEFT(A2,11)