Find missing number and name

Clean all expected result.

B2

=LET(
  a,FILTER(A2:A1000,A2:A1000<>""),
  b,Sheet2!A1:A1000,
  c,Sheet2!B1:B1000,
  d, MAP(a,LAMBDA(x,IF(SUMPRODUCT(--ISNUMBER(SEARCH(x,b&"")))>0,"","Missing"))),
  e, MAP(a,LAMBDA(x,IFERROR(INDEX(c,1/(1/(MAX(--ISNUMBER(SEARCH(x,b&""))*ROW(b)))))&"",""))),
  HSTACK(d,e)
)