Friends, I need your help on the below

Suppose in column A I have some company names or normal names, I need to do multiple word search in each cell, if matching Yes else No

For example - I want to search Davis and Patel

If A1 has Davis Erik, the result should be Yes If A2 has Sardar Patel, the result should be Yes If A3 has Davis Patel, the result should be Yes If A4 has Pamela Caro, the result should be No

Could you please help here?? Thanks in advance

CodePudding user response：

Edit: to hardcode the names:

=IFERROR(OR(IFERROR(FIND("Davis",A1,1),""),IFERROR(FIND("Patel",A1,1),"")),"No")