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.

	A	B	C	D
1	Woofter Attys			Yes
2	Woofter Inc.			Yes
3	Alaska Bar Assn			Yes
4	Jhon day			No
5	Vitalik			No

<tbody>
</tbody>

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