Excel: Search word(s) in a range of cells

Search whether anyone is living in the specific building and estate/district


=IF(OR(COUNTIF(RANGE,"*"&SEARCH 1&"*"&SEARCH 2&"*"),COUNTIF(RANGE,"*"&SEARCH 2&"*"&SEARCH 1&"*")), "Yes", "No")