How to match values and words within a string?

I got a list of word and a value, connected to that word. I want to exchange the words in the strings with the values in the wordlist and add all the values up then - the idea is to get a value of that string afterward, which indexes the "mood" of that string.

Can you help me with setting up the process? I can't find out how to match words and values and add the values up later

Thanks

Julius