If text values in range, look up numerical values that correspond and sum in one cell

I have a "pipeline" that I use to track where companies are at during various stages of a process.

- Each company has a name in column T
- Each company has a number of days from Day 1 found in column V
- Each company also has a number of "colleagues" associated with it in column W

Here is the Issue and a Discussion of the Specific Problem:
I am trying to figure out how to have one cell, K19 look at the range of L4:L17

If any of the values that exist in T3:T19 are found in L4:L17, then I need for the corresponding numerical information found in W3:W19 to be added to K19. In addition, if there are multiple twext values in L4:L17, I need K19 to SUM the corresponding # of colleagues for each of the discrete companies.

Is there a formula to do this? (I'm unable to use VB)

Thanks to anyone who can help!

SEE ATTACHED document for reference: Portfolio Pipeline.xlsx

Hi tigeravatar,

That works great! Thanks!!!

americanpiggy