Check 12 different columns for certain text? - Thank you

BrianBank

New Member
Joined
Oct 30, 2014
Messages
28
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.
[TABLE="width: 632"]
<tbody>[TR]
[TD] [/TD]
[/TR]
</tbody><colgroup><col></colgroup>[/TABLE]
 

Excel Facts

How can you turn a range sideways?
Copy the range. Select a blank cell. Right-click, Paste Special, then choose Transpose.
Put this in column F and copy down.

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

Forum statistics

Threads
1,223,231
Messages
6,170,884
Members
452,364
Latest member
springate

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top