Formula in D2:

=IFERROR(INDEX(List,MATCH(,IF(ISERR(SEARCH(B$2,List)),COUNTIF(D$1:D1,List)),)),"")



Array formula: Press Ctrl+Shift+Enter, not just Enter

Copy down