Sentence Score From Value Of Words - Excel

In Excel, I require a cell pastable formula that will return the score of a sentence based on the words contained in the sentence.

-------------------------
I have a column containing sentences

I love pandas
I hate monkeys
pandas pandas pandas
monkeys monkeys
-------------------------
2 columns containing words and their corresponding value

love 1
hate -1
pandas 1
monkeys -1
-------------------------
Expected result

I love pandas 2
I hate monkeys -2
pandas pandas pandas 3
monkeys monkeys -2
-------------------------