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.
[TABLE="width: 67"]
<colgroup><col></colgroup><tbody>[TR]
[TD]Key words[/TD]
[/TR]
[TR]
[TD]Fairmont[/TD]
[/TR]
[TR]
[TD]Raffles[/TD]
[/TR]
[TR]
[TD]Sofitel[/TD]
[/TR]
[TR]
[TD]Rixos[/TD]
[/TR]
[TR]
[TD]Mc Gallery[/TD]
[/TR]
[TR]
[TD]Gallery[/TD]
[/TR]
[TR]
[TD]Pullman[/TD]
[/TR]
[TR]
[TD]swissotel[/TD]
[/TR]
[TR]
[TD]adagio[/TD]
[/TR]
[TR]
[TD]mercure[/TD]
[/TR]
[TR]
[TD]sebel[/TD]
[/TR]
[TR]
[TD]novotel[/TD]
[/TR]
[TR]
[TD]mama shelter[/TD]
[/TR]
[TR]
[TD]ibis[/TD]
[/TR]
[TR]
[TD]formule1`[/TD]
[/TR]
[TR]
[TD]hotelf1[/TD]
[/TR]
[TR]
[TD]thalassa
[TABLE="width: 1403"]
<tbody>[TR]
[TD="class: xl68, width: 61"]Hospitality[/TD]
[TD="class: xl65, width: 61"]Partner Name[/TD]
[TD="class: xl65, width: 61"]Product ID[/TD]
[TD="class: xl65, width: 61"]Product Description[/TD]
[TD="class: xl66, width: 61"]Quantity[/TD]
[TD="class: xl67, width: 61"]Net Price Extended[/TD]
[TD="class: xl65, width: 61"]Bill To Customer Name[/TD]
[TD="class: xl65, width: 61"]Bill To Address -1[/TD]
[TD="class: xl65, width: 61"]Bill To Address -2[/TD]
[TD="class: xl65, width: 61"]Ship To Customer Name[/TD]
[TD="class: xl65, width: 61"]Ship To Address -1[/TD]
[TD="class: xl65, width: 61"]Ship To Address -2[/TD]
[TD="class: xl65, width: 61"]Ship To Country[/TD]
[TD="class: xl65, width: 61"]End User Name Details[/TD]
[TD="class: xl65, width: 61"]End User Customer Contact Email Address[/TD]
[TD="class: xl65, width: 61"]End User Address -1[/TD]
[TD="class: xl65, width: 61"]End User Address -2[/TD]
[TD="class: xl65, width: 61"]End User Country[/TD]
[TD="class: xl65, width: 61"]Campaign Code[/TD]
[TD="class: xl65, width: 61"]Comment[/TD]
[TD="class: xl65, width: 61"]Fiscal Period[/TD]
[TD="class: xl65, width: 61"]Corrected Region[/TD]
[TD="class: xl65, width: 61"]Corrected SubRegion[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[/TR]
</tbody>[/TABLE]
thanks
Astrid
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.
[TABLE="width: 67"]
<colgroup><col></colgroup><tbody>[TR]
[TD]Key words[/TD]
[/TR]
[TR]
[TD]Fairmont[/TD]
[/TR]
[TR]
[TD]Raffles[/TD]
[/TR]
[TR]
[TD]Sofitel[/TD]
[/TR]
[TR]
[TD]Rixos[/TD]
[/TR]
[TR]
[TD]Mc Gallery[/TD]
[/TR]
[TR]
[TD]Gallery[/TD]
[/TR]
[TR]
[TD]Pullman[/TD]
[/TR]
[TR]
[TD]swissotel[/TD]
[/TR]
[TR]
[TD]adagio[/TD]
[/TR]
[TR]
[TD]mercure[/TD]
[/TR]
[TR]
[TD]sebel[/TD]
[/TR]
[TR]
[TD]novotel[/TD]
[/TR]
[TR]
[TD]mama shelter[/TD]
[/TR]
[TR]
[TD]ibis[/TD]
[/TR]
[TR]
[TD]formule1`[/TD]
[/TR]
[TR]
[TD]hotelf1[/TD]
[/TR]
[TR]
[TD]thalassa
[TABLE="width: 1403"]
<tbody>[TR]
[TD="class: xl68, width: 61"]Hospitality[/TD]
[TD="class: xl65, width: 61"]Partner Name[/TD]
[TD="class: xl65, width: 61"]Product ID[/TD]
[TD="class: xl65, width: 61"]Product Description[/TD]
[TD="class: xl66, width: 61"]Quantity[/TD]
[TD="class: xl67, width: 61"]Net Price Extended[/TD]
[TD="class: xl65, width: 61"]Bill To Customer Name[/TD]
[TD="class: xl65, width: 61"]Bill To Address -1[/TD]
[TD="class: xl65, width: 61"]Bill To Address -2[/TD]
[TD="class: xl65, width: 61"]Ship To Customer Name[/TD]
[TD="class: xl65, width: 61"]Ship To Address -1[/TD]
[TD="class: xl65, width: 61"]Ship To Address -2[/TD]
[TD="class: xl65, width: 61"]Ship To Country[/TD]
[TD="class: xl65, width: 61"]End User Name Details[/TD]
[TD="class: xl65, width: 61"]End User Customer Contact Email Address[/TD]
[TD="class: xl65, width: 61"]End User Address -1[/TD]
[TD="class: xl65, width: 61"]End User Address -2[/TD]
[TD="class: xl65, width: 61"]End User Country[/TD]
[TD="class: xl65, width: 61"]Campaign Code[/TD]
[TD="class: xl65, width: 61"]Comment[/TD]
[TD="class: xl65, width: 61"]Fiscal Period[/TD]
[TD="class: xl65, width: 61"]Corrected Region[/TD]
[TD="class: xl65, width: 61"]Corrected SubRegion[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[/TR]
</tbody>[/TABLE]
thanks
Astrid