How to Return matched value in a column in same roy if a cell matches one of the texts in another column ?

[mosesdavid1103]

How To Return the matched Value In column D in the same row, If A Cell partially matches one of the texts in Column F using Excel or VBA ?
Column F

UW Issue

New Business

Policy Change

Reinstatement

Rescind

Rating

Cancellation

Driver

Vehicle

 

[mart37]

Have you tried SUMIF?

 

[mosesdavid1103]

Have you tried SUMIF?

Yes

 

[Fluff]

What are the values in col A that you are trying to match?