Replacing values from a Cell by Reference values

Hello

Is it possible to replace multiple comma separated values in excel cell by values in reference column?

Please refer the attachment.

Example
If I type A2, A5 in cell C2 then it should replace the value as Apple, Dog.