Check 12 different columns for certain text? - Thank you

[BrianBank]

Hello Excel,

Looking for some assistance on the following problem:

I have a keyword in column "E" that goes down approximately 4,000 rows.

Columns A - D have the following rules

1. They contain no text
2. They contain the specific keyword in column "E"
3. It contains the specific keyword, but also contains other text in the cell.

How can I check columns A-D for the specific keyword in column "E" and return that in column "F". Please keep in mind I am doing this for 4,000+ rows.

I am essentially doing this to check if the four columns have this specific keyword somewhere in the 4 different columns with the above parameters.

Thank you to anyone who can help.

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

 

[Norie]

Put this in column F and copy down.

=IF(COUNTIF(A2:D2, "*" & E2 & "*")>0, E2, "")

 

[BrianBank]

This is incredible Norie, I can't thank you enough for your generosity.

 

[SREEMOORTHYP]

Hi,

Can You Share model file for reference...