Auto-Populate Cells Based on Input

[JRC_Design]

Hello Everyone! I'm a landscape architect and part of my job is working on Tree Preservation Plans. Basically what I'd like to do is input the Species, DBH, & ACTION (In Yellow) and have it populate the cell (In Green) based on the category in F3:N3 (Significant Trees, Heritage Trees, Etc..). The categories table has been attached as well.

I'm usually able to solve my Excel issues but this one is a bit over my head. I'd appreciate any solutions or suggestions you may have. Thanks in advance!!

	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q
2	DESCRIPTION					SMALL TREE / UNDERSTORY SPECIES				TREES							TREES 2.5" TO 6"
3	TREE NUMBER	SPECIES	DBH	ACTION	COMMENTS	SIGNIFICANT TREES: 5" TO 12"		HERITAGE TREES: GREATER THAN 12"		SIGNIFICANT TREES: 6" TO 24"		SIGNIFICANT TREES: 10" TO 24"		HERITAGE TREES: GREATER THAN 24"+
4						TO REMAIN	TO BE REMOVED	TO REMAIN	TO BE REMOVED	TO REMAIN	TO BE REMOVED	TO REMAIN	TO BE REMOVED	TO REMAIN	TO BE REMOVED (3:1 MITIGATION)	TO BE REMOVED (1:1 MITIGATION)
5	1061	LIVE OAK	12	PRESERVE						12
6	1062	HACKBERRY	15	REMOVE									15
7	1063	TEXAS PERSIMMON	5	PRESERVE		5
8	1064	PECAN	40	PRESERVE										40
9	1065	HACKBERRY	28	REMOVE												28
10	1066	TEXAS REDBUD	8	REMOVE			8
11	1067	BUR OAK	6	REMOVE							6
12	1068	MESQUITE	17	PRESERVE								17
13	1069	LIVE OAK	24	REMOVE											24
14	1070	TEXAS MOUNTAIN LAUREL	12.5	PRESERVE				12.5
15	1071	TEXAS PERSIMMON	13	REMOVE					13
16	1072	MONTERREY OAK	4.5	PRESERVE													4.5
17	1073	ANACACHO ORCHID TREE	3	REMOVE													EXEMPT
18	1074	CHINABERRY	20	REMOVE									INVASIVE - EXEMPT
19	1075	SALT CEDAR	26.5	REMOVE												INVASIVE-EXEMPT
20	1076	MESQUITE	2	PRESERVE													EXEMPT
21
22	SUBTOTAL INCHES					5	8	12.5	13	12	6	17	15	40	24	28	4.5
23	TOTAL INCHES BY CATEGORY					13		25.5		18		32		92
24
25	UNDERSTORY PRESERVATION
26	UNDERSTORY HERITAGE PRESERVATION
27
28	SIGNIFICANT PRESERVATION
29	HERITAGE PRESERVATION (1:1 MITIGATION)
30	HERITAGE PRESERVATION (3:1 MITIGATION)
31
32	MITIGATION REQUIRED
33	HERITAGE MITIGATION REQUIRED
34
35	No category to fall below 20% preservation;
36	Preserved- Tree to remain that meets root protection zone requirements described in section 35-523 of the UDC.
37	Mitigation 1:1 for significant trees below minimum preservation requirements; 3:1 for heritage trees below 100% preservation
38	* Small species: Condalia, Redbud, Tx. Mountain Laurel, Tx. Persimmon, Hawthorn, Possumhaw - these are mitigated at 1:1 for Heritage Trees
39	** Ashe Juniper, Huisache, Mesquite, Arizona Ash, Hackberry protected at 10" dbh and mitigated at 1:1 for heritage trees
40	*** Mitigation Trees: Unprotected-sized trees to be used for mitigation calculations; subtract inches from mitigation owed
41	**** Unprotected Trees: Removed not counted

<tbody>
</tbody>

TP - EXAMPLE​

	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O
1	SIGNIFICANT TREES: 5" TO 12"		HERITAGE TREES: GREATER THAN 12"		SIGNIFICANT TREES: 10" TO 24"		HERITAGE TREES: GREATER THAN 24"+ /// 1:1 MITIGATION		SIGNIFICANT TREES: 6" TO 24"		HERITAGE TREES: GREATER THAN 24" /// 3:1 MITIGATION		TREES: 2.5" TO 6"		NON-NATIVE /// INVASIVE
2	TEXAS PERSIMMON		TEXAS PERSIMMON		ASHE JUNIPER		ASHE JUNIPER		Anacacho, Orchid tree*		Anacacho, Orchid tree*		TEXAS PERSIMMON		CHINESE PISTACHE
3	TEXAS REDBUD		TEXAS REDBUD		HUISACHE		HUISACHE		Anaqua*, Sandpaper tree		Anaqua*, Sandpaper tree		TEXAS REDBUD		CHINABERRY
4	TEXAS MOUNTAIN LAUREL		TEXAS MOUNTAIN LAUREL		MESQUITE		MESQUITE		Arizona Cypress		Arizona Cypress		TEXAS MOUNTAIN LAUREL		CHINESE TALLOW
5	CONDALIA		CONDALIA		ARIZONA ASH		ARIZONA ASH		Bald Cypress**		Bald Cypress**		CONDALIA		TREE OF HEAVEN
6	POSSUMHAW		POSSUMHAW		HACKBERRY		HACKBERRY		Big Tooth Maple**		Big Tooth Maple**		POSSUMHAW		SALT CEDAR
7	HAWTHORNE		HAWTHORNE		FRAXINUS		FRAXINUS		Black Willow*		Black Willow*		HAWTHORNE		JAPANESE LIGUSTRUM
8									Bur Oak*		Bur Oak*		ASHE JUNIPER		NANDINA
9									Carolina Buckthorn*		Carolina Buckthorn*		HUISACHE		PAPER MULBERRY
10									Cedar Elm*		Cedar Elm*		MESQUITE
11									Chinquapin Oak*		Chinquapin Oak*		ARIZONA ASH
12									Cottonwood*		Cottonwood*		HACKBERRY
13									Crabapple, Texas*		Crabapple, Texas*		FRAXINUS
14									Desert Willow*		Desert Willow*		Anacacho, Orchid tree*
15									Deodar Cedar		Deodar Cedar		Anaqua*, Sandpaper tree
16									Ebony, Texas*		Ebony, Texas*		Arizona Cypress
17									Escarpment Black Cherry*		Escarpment Black Cherry*		Bald Cypress**
18									Eve's Necklace*		Eve's Necklace*		Big Tooth Maple**
19									Goldenball Lead Tree*		Goldenball Lead Tree*		Black Willow*
20									Honey Locust		Honey Locust		Bur Oak*
21									Italian Stone pine		Italian Stone pine		Carolina Buckthorn*
22									Kidneywood*		Kidneywood*		Cedar Elm*
23									Lacy Oak*		Lacy Oak*		Chinquapin Oak*
24									Live Oak*		Live Oak*		Cottonwood*
25									Monterrey Oak		Monterrey Oak		Crabapple, Texas*
26									Montezuma cypress**		Montezuma cypress**		Desert Willow*
27									Mexican Buckeye*		Mexican Buckeye*		Deodar Cedar
28									Pecan*		Pecan*		Ebony, Texas*
29									Plum, Mexican*		Plum, Mexican*		Escarpment Black Cherry*
30									Retama, Paloverde*		Retama, Paloverde*		Eve's Necklace*
31									Red Oak, Shumard*		Red Oak, Shumard*		Goldenball Lead Tree*
32									Red Oak, Texas*		Red Oak, Texas*		Honey Locust
33									Rusty Blackhaw*		Rusty Blackhaw*		Italian Stone pine
34									Silk-tassle*		Silk-tassle*		Kidneywood*
35									Sycamore, Mexican		Sycamore, Mexican		Lacy Oak*
36									Sycamore,Texas*		Sycamore,Texas*		Live Oak*
37									Texas Pistache*		Texas Pistache*		Monterrey Oak
38									Western Soapberry*		Western Soapberry*		Montezuma cypress**
39									Wild Olive*		Wild Olive*		Mexican Buckeye*
40									Yaupon Holly*		Yaupon Holly*		Pecan*
41													Plum, Mexican*
42													Retama, Paloverde*
43													Red Oak, Shumard*
44													Red Oak, Texas*
45													Rusty Blackhaw*
46													Silk-tassle*
47													Sycamore, Mexican
48													Sycamore,Texas*
49													Texas Pistache*
50													Western Soapberry*
51													Wild Olive*
52													Yaupon Holly*

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

CATEGORIES​

 

[JRC_Design]

bump... Please feel free to ask me any questions if necessary! Thanks!

 

[JRC_Design]

bump.

 

[JRC_Design]

bump