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

Copy a format multiple times
Select a formatted range. Double-click the Format Painter (left side of Home tab). You can paste formatting multiple times. Esc to stop
Put this in column F and copy down.

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

Forum statistics

Threads
1,223,903
Messages
6,175,289
Members
452,631
Latest member
a_potato

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