Hi Friends

I have a scenario, there is values in sheet 1 column B and i have to match them with Coulmn B, Column C and if there is a match of first word in a cell add the values which is in Coulmn D.

Please help me with the above scenario.

Thanks in advance.