Fill a value in the cell according multiple search terms in the other cells of a Column.

[veer-india]

Here i make an example table, and the main task what i want to do. an excel file mix of lawyers and agencies names mixed under a single column. I want fill column D with yes if the Stuff in A is Law agency, (using search terms attys, inc. bar, assn) like this and seprate the agencies from the layers bye sorting using yes no in D.
[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD][/TD]
[TD]A[/TD]
[TD]B[/TD]
[TD]C[/TD]
[TD]D[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]Woofter Attys[/TD]
[TD][/TD]
[TD][/TD]
[TD]Yes[/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD]Woofter Inc.
[/TD]
[TD][/TD]
[TD][/TD]
[TD]Yes[/TD]
[/TR]
[TR]
[TD]3[/TD]
[TD]Alaska Bar Assn[/TD]
[TD][/TD]
[TD][/TD]
[TD]Yes[/TD]
[/TR]
[TR]
[TD]4[/TD]
[TD]Jhon day[/TD]
[TD][/TD]
[TD][/TD]
[TD]No[/TD]
[/TR]
[TR]
[TD]5[/TD]
[TD]Vitalik[/TD]
[TD][/TD]
[TD][/TD]
[TD]No[/TD]
[/TR]
</tbody>[/TABLE]

How can i fill D with yes and no at a single Stroke on the basis of multiple search terms (attys, inc., assn) thank you very much.

 

[JoeMo]

Copy D1 down.

Excel Workbook
	A	B	C	D
1	Woofter Attys			yes
2	Woofter Inc.			yes
3	Alaska Bar Assn			yes
4	Jhon day			no
5	Vitalik			no
Sheet3