Excel formula to search keaywords in multiple columns

[simbaloo]

Hello,
I need your help please, I need to find a formula to search in multiple columns if the cell contains specifics key words if it is the case I need to flag the result = hopitality.

Key words

Fairmont

Raffles

Sofitel

Rixos

Mc Gallery

Gallery

Pullman

swissotel

adagio

mercure

sebel

novotel

mama shelter

ibis

formule1`

hotelf1

thalassa Hospitality Partner Name Product ID Product Description Quantity Net Price Extended Bill To Customer Name Bill To Address -1 Bill To Address -2 Ship To Customer Name Ship To Address -1 Ship To Address -2 Ship To Country End User Name Details End User Customer Contact Email Address End User Address -1 End User Address -2 End User Country Campaign Code Comment Fiscal Period Corrected Region Corrected SubRegion <tbody> </tbody>

<colgroup><col></colgroup><tbody>
</tbody>

thanks
Astrid

 

[oldbrewer]

which column(s) will for exmple novotel be found in ?

 

[simbaloo]

in any columns but on the same row

 

[oldbrewer]

will novotel be the only thing in the cells, or maybe novotel hotel ?