Hi,

There is no need for an array function ...

=IF(ISNA(MATCH("MICHAEL",WS2!A1:A12,0)),"","Yes")
HTH
Carim