Searching two columns for one word

[Steve_123]

Hello

I need to look for a single word in two columns A and B which contain multiple words and then return that word with the totals of columns C and D. I've attached a sample book which should hopefully make it clearer.

Thanks in advance for help