Check if in column A some words are present

[assurdo]

Hi,
how do I check, with a macro, if a .txt file that I have imported in Excel, contains some word? If it contains them, I need to show a error message, if it does not contain it, it's fine.
When the file txt is imported in Excel, it is in the worksheet "Import". So I can check in the column A of "Import" is the words are found. Thank you.

 

[nardagus]

I don't know of the amount of the data you need to import.
I came up with a formula. First some info.

I created two sheets:
- Import - this one contains imported data (obviously )
- Verification - this one contains keywords to search for and a searching formula


Excel 2016 (Windows) 32 bit

	A
1	Imported data
2	Imp1
3	Imp2
4	car
5	forest
6	something
7	smthelse
8	anything
9	home
10	sky

<tbody>
</tbody>

Import sheet above​

Excel 2016 (Windows) 32 bit

	A	B	C
1	keyword to look for	Keywords found?	Amount of keywords found
2	car	Keywords found!	2
3	forest

<colgroup><col style="width: 25pxpx"><col><col><col></colgroup><thead>
</thead><tbody>
</tbody>

Verification sheet​

Array Formulas Cell Formula B2 {=IF(SUM(IF(ISERROR(MATCH(A2:A4,Import!$A$2:$A$13,0)),0,1))>0,"Keywords found!","")} C2 {=SUM(IF(ISERROR(MATCH(A2:A4,Import!$A$2:$A$13,0)),0,1))} <thead> </thead><tbody> </tbody> Entered with Ctrl+Shift+Enter. If entered correctly, Excel will surround with curly braces {}. Note: Do not try and enter the {} manually yourself

<tbody>
</tbody>

What do you think?

 

[assurdo]

I don't know of the amount of the data you need to import.
I came up with a formula. First some info.

I created two sheets:
- Import - this one contains imported data (obviously )
- Verification - this one contains keywords to search for and a searching formula


Excel 2016 (Windows) 32 bit

	A
1	Imported data
2	Imp1
3	Imp2
4	car
5	forest
6	something
7	smthelse
8	anything
9	home
10	sky

<tbody>
</tbody>

Import sheet above​

Excel 2016 (Windows) 32 bit

	A	B	C
1	keyword to look for	Keywords found?	Amount of keywords found
2	car	Keywords found!	2
3	forest

<tbody>
</tbody>

Verification sheet​

Array Formulas Cell Formula B2 {=IF(SUM(IF(ISERROR(MATCH(A2:A4,Import!$A$2:$A$13,0)),0,1))>0,"Keywords found!","")} C2 {=SUM(IF(ISERROR(MATCH(A2:A4,Import!$A$2:$A$13,0)),0,1))} <tbody> </tbody> Entered with Ctrl+Shift+Enter. If entered correctly, Excel will surround with curly braces {}. Note: Do not try and enter the {} manually yourself

<tbody>
</tbody>

What do you think?

It's fine, thank you!
Another solution can be:

1) Formula in cell B10 for example: =CONTA.SE(Import!A:A; "Word to search")
+
2) Macro: If Range("B10") > 0 Then MsgBox "....."

 

[nardagus]

Ooooh. You want to look for one word only?

That does change things a bit.

Your macro is almost ready. Do you still need assistance with it?

One more thing. My previous formula can be wrote differently:

Excel 2016 (Windows) 32 bit

	B
3	Keywords found!

<colgroup><col style="width: 25pxpx"><col></colgroup><thead>
</thead><tbody>
</tbody>

Verification​

Array Formulas Cell Formula B3 {=IF(SUM(IF(COUNTIF(Import!$A$2:$A$13,Verification!A2:A4)>0,1,0))>0,"Keywords found!","")} <thead> </thead><tbody> </tbody> Entered with Ctrl+Shift+Enter. If entered correctly, Excel will surround with curly braces {}. Note: Do not try and enter the {} manually yourself

<tbody>
</tbody>