Add values found after vlookup matches multiple occurances of the search criteria

I have a list of names in column B and time worked on a project in column C. I am trying to figure out how to use the 'VLOOKUP' and 'SUM' together to calculate the total time each person spent on the project. The names are listed again in Column D and the total spent is in Column E. Do I need to use both these functions or is one sufficient?
Column B--------Column C--------Column D---------Column E
--John--------------25-----------------John----------------?
--Brian-------------15-----------------Tyler----------------?
--Josh--------------20-----------------Brian---------------?
--Tyler------------101-----------------Josh----------------?
--Albert------------45----------------Albert----------------?
--Tyler-------------26
--Josh--------------48
--Brian-------------52

Can someone please help?

Or use a pivot table for that kind of work.

@rod642

I suggest you to start with an small project, to learn pivot table.

When you know the basic technics, it is easy to implement in a larger project.