Find and replace multiple values within individual cells

I'm new to this forum/advanced excel, so please forgive any errors.

So I have a list of organizations in Column A, with multiple names (anywhere from 0 to 50 names) for each org. in Column B.

Org	Names
Company A	Brown, Jones, Smith, West
Company B	Brown, Evans, Smith

Separately, I have a list of corresponding values for each name:

Brown	Red
Jones	Red
Smith	Blue
Etc.	Etc.

I want to do a find and replace for all of Column B, where all the names are replaced with their respective color values. If possible, I'd like this to all happen with the individual cells (so for example, B3 might go from "Brown, Jones, Smith" to "Red, Red, Blue").

If that's not possible, I could divide all the names into individual cells and then find and replace.

Is what I want feasible? Am I making any sense? Thanks for any help.

If there are too many names to do this manually with Find & Replace, then a short VBA macro would do it. Note that the code has to avoid scenarios like this:

Rumpelstiltskin	Brown
Brown	Red
Jones	Red
Smithe	Green
Smith	Blue

If you replace all Rumpelstiltskins first, then replace all Browns, then Rumpelstiltskin will end up a Red instead of Brown.

If you do a simple find & replace, then Smithe ends up as Bluee and never becomes Green.

I have attached a solution based on your sample data.