Find words and associate to a value in Google Sheets

I got a list of items with several values validated from a list. Each value is a word which I would like to associate with a number and attribute a score:

For instance: Michael's evaluation contains Proactive, two Not Technically Capable, and Quick Learner, so according to the Profile/Value table, Michael scored 4.

Here is the URL: https://docs.google.com/spreadsheets/d/1DD2jnS0M1z1f6i7wHImbiiyDcLv-M2vq3fio1sry4Do/edit?usp=sharing

Thank you!